TODAY fucntion in a formula / conditoinal format?

  • Thread starter Thread starter bludovico
  • Start date Start date
B

bludovico

Okay, here's another easy one. I want a formula that basically says "IF
DATE IN COLUMN D => TODAY, THEN COLOR = RED." I can do the conditional
format, but I'm having trouble figuring out the formula syntax. Any
help?
 
Is this part of a macro or VBA?

If not you can do it with conditional formatting at a cell level.

If A1 contains the date then use Format, Conditional Formatting,
set condition1 to "formula is" then enter +A1=today() and your choice
of formatting options.
You can then transfer this conditional format to other cells or to the
whole column
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MAcro Problem (probably easy) 2
Trouble w/ conditional formatting and dates 5
[Flashing] RED before renewal date 1
Conditoinal format trouble 3
if then and conditional formatting of dates 2
Sumif ">today()" 1
conditional formating 3
Conditional formatting with formula 3

Back
Top