You're welcome!

--
Biff
Microsoft Excel MVP


"Pluribus" wrote in message
...
Thanks very much - You have both helped a lot!

"smartin" wrote:

Pluribus wrote:
Hi

I need to create a formula which takes the date in cell A1, adds 358
days,
and if the result is todays date or later return a value of Yes in a
coloured
cell, otherwise return a value of No in a plain cell.

My Date format is DD/MM/YYYY.

Thanks for your help in advance!

Formula in your cell (say z1)
=if(a1+358=today(),"Yes",No")

Conditional Formatting in z1:
Cell Value Is
Equal To
Yes
Click Format and paint as needed.