i need the date to flag up red if it goes over 30 days from the d.

[Pali]

i need the date to flag up red if it goes over 30 days from the date it was
logged

 

[Mike H]

Use conditional formatting on your date cell

Cell value is - Less than - ="today()-30"

Mike

 

[Mike H]

Pali,

Please ignore previous post which is completely wrong!!!

Still conditional formatting so with your date in A1 press

Format - conditional formatting - formula is - =(TODAY()-A1)>30

and apply your colour.

Mike

 

[Pali]

i have type the following i the cell =(TODAY()-A1)>30 and it came up false.
and if i appy the colour will that come up for as many itme i put in

 

[Toppers]

Select Column A

Then FORMAT==> Conditional Formatting:

FormulaIS: =AND(A1<>"",TODAY()-A1>30)

Select colour.

OK

 

[Pali]

if i wantd to do more than one cell how would i do it

 

[Pali]

i am no i may sound stupid sorry.
i have a speadsheet that has date already in it and some dont. but i would
like for them to flag up in any colour to let me know they have gone over 30
days.
i want to flag up from l3 to l50