Condtional Formatting

Good morning!

I am working on an Excel sheet to track customer status for storage units we have.

I have successfully programmed condtionnal formatting for two options, but I am having difficulty with the third.

What I have set up is If the date (in a certain cell in a different sheet) is greater than today, the group of cells selected are green. If the date is less than today, the group of selected cells are red.

What I am trying to do, If there is no date, I want the group of selected cells to be Orange.

Please Help!!!

Maybe:

=A1=""


No idea what cells you are formatting so you'll need to translate

Regards

Post a sample workbook, please.

Condition 1: Formula is: =$B$13=0 ... amber
Condition 2: Formula is: =$B$13>TODAY() ... green
Condition 3: Formula is: =$B$13<TODAY() ... red

The reason is that if the cell is empty, the link will return 0, not blank.


Regards

Put 0 in a cell. Format the cell as Date. What do you see before you format it? What do you see after you format it? What you are seeing is a zero being returned from the link and your formatting presenting it as the date 00/01/1900.

To return a space, you'd need something like, =IF(Sheet2!B13=0,"",Sheet2!B13)

Regards

This:

=SI('1'!B8;'1'!B8;0)

is not the same as this:

=IF(Sheet2!B13=0,"",Sheet2!B13) or =IF(Sheet2!B8=0,"",Sheet2!B8)

even in French.

You'd need something like this:

=SI('1'!B8="";"";'1'!B8)

This says, if the value in cell B8 on sheet 1 is blank (null), return null, otherwise return value in cell B8 on sheet 1.

Have a look at the updated example for formula and Conditional Formatting examples.


Regards

You're welcome. Thanks for the rep.

Regards