Try this...

=IF(A1+358=TODAY(),"Yes","No")

Use conditional formatting th color the cell.
Assume the cell is B1
Select cell B1
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the little box to the right:
=B1="Yes"
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"Pluribus" wrote in message
...
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!