Conditional Formatting Cell < Today()

S

sagan

I always have issues with conditional formatting when I want to use
formula and pointing at the value of the same cell.

Here is the problem:

Due Date is in A1

if(Due Date < today()) do formatting


I tried using
Cell Value is | less than | today() but when I enter that it just put
" " around today as if it is text.

When I use Formula Is, I'm not sure how to reference back to the cel
in question.


This format needs to be copied down indefinitely in the due dat
column. So I'm trying to write a formula where I can select th
column then go to conditional formatting and write the formula.


I know this SHOULD be easy but like I said the conditional formattin
interface is strange to me (compared to using worksheet formulas o
vba
 
S

sagan

I'm dumb here we go:

=IF(A1<TODAY(),TRUE,FALSE)

You have to make sure to specify true or false it is not automaticall
returned.. i.e.
if(a1<today()) is not going to work
 
S

swatsp0p

Sagan:

Try this in your CF:

In cell A1, click Format>Conditional Formatting...

Condition 1:

Formula Is: "<Today()" (no quotes).

Set desired formatting.

You don't need to reference the cell you are in if the value of that
cell is what you are basing your condition on.

Also works:

Cell value Is: Less Than: ="today()" (entered exactly as shown)

HTH

Bruce
 
Top