Today's date

S

sixwest

Hello:

I'm attempting to set-up a spreadsheet so certain cells will automatically
change pattern colors on certain dates.

EXAMPLE: Current date is entered in cell A1. Cell A2 will be entered as "A1
+ 15".
What would the conditional formatting formula be so that when "A1 + 15"
becomes the current date, cell A2 will automatically change pattern and/or
font?:

Thanks
 
B

Bernard Liengme

Use Format | Conditional Formatting
Change the left box to "Formula is" and in Formula Box enter =TODAY()
Alternatively, you could use =A2=TODAY()
Now kick the Format button and select a colour and/or font as needed

If you want the formatting to apply on subsequent days use this formula:
=A2>=TODAY()

best wishes
 
G

Guest

Hi

In Conditional Formatting use Formula Is and in the box type
=A2=TODAY()
and set your format.

Andy.
 
Top