Conditional Format not working

[Carnie]

Sponsored Links

Hello
I have an problem in excel. I put a conditional formatting on a cell that is:
If the box next to (eg A1) is empty, the box (B1) should remain white, but that does not work! I can not represent the word "empty".
Here is what I do

SI =(N21 ="";1;0)

Any ideas about this. This is not working with me.

[Macarenas]

Hi
In the conditional format, you should keep in mind that if you take a formula with relative references, they are relative the active cell at the time of the creation of the MFC. To test whether cell left active cell is empty or not, you gotta put in a cell and enter the cell reference left in mfc. Selected test on a formula, as formula, before this, after analog and digital recording placed O21

= (N21 = "")

Hope this will help you. If any query please do post back.

[Carnie]

Hi
Selected test on a formula after analog and digital recording placed O21. I did not really understand. So I tried in my MFC. I have this with me now.

=(N21 ="")

but can not change anything here. Can you re-explain please?

[Macarenas]

Hello
Selects the cell or range of cells which must change color. This must be in the conditional formatting, the tape in place that offers a formula = cell = "" and is careful that can be written without ca $ and correspond to the cell of high area you have selected
For example, if you want the range C20 to C30 is colored based on whether the corresponding cell range F20 to F30 is empty or not selected must C20: C30 and type = F20 = "" (and choose a formatting).
If you type = $ F $ 20 = "," your whole range C20: C30 will be colored or not a stroke as if F20 is empty or not (and never looks F21: F30).
If you type = F21 = "", your cells will color depending on whether the cell line below is empty or not.

[Carnie]

Hi
Ok, that's what I did. In fact it is not working because I have two MFC contradictory in the same cell.
The first:

SI =(N25 ="";1;0)

The second:

SI =(N25 <= K25;1;0)

Let me explain what I do:
I compare two dates in dd / mm / yyyy in column N and K. Column K is already full, whereas the N column fills up as missions.
The problem is that condition 2 is calculated every time even if the box is empty so my condition has 1 more reason to be. I think to clear my problem I would have to say somewhere that condition 2 is valid only if the value of cell N is of the form dd / mm / yyyy, right?

[Macarenas]

Hello

SI =(N25 ="";1;0)

And this

SI =(N25 <= K25;1;0)

If you want to make work this.
There is an order of application to the MFC, just inverse it. This trick has worked with me. Hope this will work with you. If you have any more problem, then please do post back.