Thread
:
Conditional format with a formula
View Single Post
#
5
Mike Echo
Posts: n/a
In article ,
says...
Assume dates are in the range A1:A10
Select the range A1:A10
Goto FormatConditional Formatting
Formula is: =A1=TODAY()
Click the Format button and select the style you'd like
OK out
Assume I have a column of dates. I want that column to be conditionally
formatted so that today's date will be red for example. I enter
=NOW()=1
in the formula for the conditional format but she no go. I tried TODAY
(), etc too.
Any ideas?
Yep, it works. Thanks, Biff!
Anyone care to enlighten me why it works? I don't understand why the
reference to A1 when the whole range is subject to the format.
Reply With Quote