Conditional format with a formula

  • Thread starter Thread starter Mike Echo
  • Start date Start date
M

Mike Echo

I have done this before but for the life of me cannot remember how I did
it.

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?

TIA,
R.
 
Hi!

Try this.....

Assume dates are in the range A1:A10

Select the range A1:A10
Goto Format>Conditional Formatting
Formula is: =A1=TODAY()
Click the Format button and select the style you'd like
OK out

Biff
 
Assume dates are in the range A1:A10

Select the range A1:A10
Goto Format>Conditional Formatting
Formula is: =A1=TODAY()
Click the Format button and select the style you'd like
OK out
Click to expand...

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.
 
Mike,

Don't know why you are comparing the date to 1 but you are correct it
realising you need to force a True/False result. In this instance, you need
to determine whether the cell has today's date it in, so select all of the
cells, starting at A1 say, and use a formula of

=A1=TODAY()
 
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.
Click to expand...

Never mind. Looked at the format for various cells within the range and
see how it works now. Thanks to all those who replied (you too Bob!) :-)
 
Back
Top