Hi Roger,

I also want to conditional format the cells in a column column for date
after 2001.

I highlighted the whole column, then Format | Conditional format and entered
the same formula =$Y2DATE(2001,1,1) and chose blue.....so when a date is
entered in any cell in column B, the cell is formatted as blue....the problem
is it formats the cell above the cell the date is entered....i.e. enter date
in A3, and the formatting is wrongly applied to cell A".what am I overlooking.

Thanks again.

"Dermot" wrote:

Hi Roger,
Thanks for your formulae, they worked fine.
Please advise a little further.......I spent quite a while trying to figure
out the logic of he expression I was trying to determine......I knew I was
complicating matters!

=$R6--("1/1/2001")
From left to right the above formula read Cell $R6 is greater than
1/1/2002..................can I put from and to dates in the brackets, if so
what would the syntax be......or how would I adapt the formula.
or
=$R6DATE(2001,1,1)
Reads..........$R6 is greater than.......how do I interpret the contents of
the brackets?....Year, Month, day....the 1,1 representing month and day?
--
Thanks

Dermot


"Roger Govier" wrote:

Hi Dermot
Try
=$R6--("1/1/2001")
or
=$R6DATE(2001,1,1)
--
Regards
Roger Govier

"Dermot" wrote in message
...
I want to conditional Format Rows depending on there being a date entered
in
Cell $R6, so the Row goes Yellow.

If there are no dates within column R6, I want the Cell to remain blank

I have tried using several formula, to no success, the las being,
=IF(DATE(1/1/2001),1,"") .............for condition 1

Assistance would be appreciated how I can achieve this.

Thanks in advance