conditional formatting

[colpos1]

Hi all Ok so I have a date entered into cell H4 in Cell K4 a dateis entered when a payment has been received, what I am after is for Cell K4 togo red after 30 days if no date has been entered into Cell K4.

 

[Yongle]

with K4 selected \ conditional formatting\ new rule \ use formula to determine ...

=(TODAY()-29-H4>0)*(K4="")


So formatting only happens if BOTH cell is empty AND value in H4 is 30 days (or more) before current date

 

[colpos1]

Thats great Yondle, is there a way the rule does not go red if no date is in CellH4 ? it,s just i have to put this rule into a whole column and the cells have turned red without anything entered into cell H4

 

[Yongle]

How about

=(TODAY()-29-H4>0)*(K4="")*(H4>0)

 

[colpos1]

Well done Yongle works a treat thanks for your help really appreciated