Conditional formatting inconsistently applied

[Robin]

I have set up some cells with condtional formatting so
that if the date in the cell is before today's date, the
cell contents will be red. This works on some cells, but
not others.

The formula in the cell (e.g., B13) is: =EDATE(B12,24)
The format of the cell is: date mm/dd/yy
Conditional formatting is: cell value is less than
37889 format red

Any help on getting this CF applied consistently? thanx

 

[David McRitchie]

Hi Robin,
Did you test your formula by using another column,
anything that is zero is False, any other numeric value is True

select column B
if the B1 is the active cell then
C.F. Formula 1: =$B1<today()
or better this formula: =AND(ISNUMBER($B1),$B1<TODAY())

use of $B instead of B allows you to select the entire sheet
instead of just column B, so that the entire rows will be highlighted.

More information on Conditional Formatting in
http://www.mvps.org/dmcritchie/excel/condfmt.htm