Conditional formatting

[Alan3770]

I am looking for a little help with a formula in conditional formatting. I have attached a screen shot of what I am trying to achieve, but basically I want a cell to highlight amber if the date in the previous cell is = or > 1 month old. The formatting should revert back to normal once a date has been input.

Thanks in advance

[Roel Jongman]

change the CF-function to

=IF(B5="",TODAY(),B5)-A5>30

and then the it should turn amber whenever there are more then 30 days between 2 dates

But that might not bee what you need. If you want a more fitting solution please upload the example sheet instead of a screenshot so we can see the current formula in CF and adjust that to your needs.
Now it is mostly guesswork what you need exactly.

[Alan3770]

Roel,
Thank you for your reply. I have attached as an excel spreadsheet. The formula you sent does change the cell amber if they are over 30 days but they remain at amber once a date has been input (I want it to revert back to white). Also if there is no date in column A ( like in A6) no formatting should occur in Column B

[Fluff13]

How about
=AND(A3<>"",B3="",TODAY()-A3>30)

[Alan3770]

Fluff,
That seems to work, thank you so much

[Fluff13]

You're welcome & thanks for the feedback