Conditional Formatting
Thanks Roger
Regards
Dermot
"Roger Govier" wrote:
Hi Dermot
Date has 3 parameters =Date(Year,Month,Day)
If you want to combine to and from dates then
=AND($R6=DATE(2008,1,1),$R6<=DATE(2008,1,31))
would include all dates from 1st to 31st January 2008
--
Regards
Roger Govier
"Dermot" wrote in message
...
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
|