Conditional Formatting in Excel 2010

[DaveNJ0124]

Say i have in cell A1 a date, 2/4/13, and I want to put a formula in another cell to have the word 'Expired' fill in when the actual date is past 2/4/13?

 

[Luke M]

Can't be done with conditional formatting, but the regular formula to put in the other cell would be:

=IF(TODAY()>A1,"Expired","Sill good!")


If you need to use Conditional Formatting, I suggest formatting A1 with this formula:

=TODAY()>A1

and set it to use the Strikethrough (on Font tab). So, expired dates get crossed off.

 

[chris_pwi]

Another Conditional Format related question:


What if I want to format a cell with a fill color (say light red, dark red font) only when it is completely blank but as soon as anything is input in the cell (space included) it reverts to standard sheet format?


Easy, I'm sure. Just having a brain cramp.


Thanks!

 

[Luke M]

Hi chris_pwi,

In the future, you should start a new thread instead of tacking on to someone else's. It's easy for an already answered thread to get overlooked, and you won't get your answer. =(


To address the question however, your CF formula would be:

=ISBLANK(A2)

This will evaluate to False even if the user puts a space, or contains a formula.

 

[chris_pwi]

Awesome! Thanks Luke, problem solved! Will start new thread next time.