Change cell colour

[Ron Sivers]

Can anyone advise on changing cell colour when cell criteria has bee
met i.e when date entered has been exceeded by 14 days the cell change
to another predetermined colou

 

[norika]

Ron,

Please try Format / Conditional Formatting.

HTH

norik

 

[Debra Dalgleish]

You can use Conditional Formatting, with the TODAY function:

Select the cell that you want to colour (A2 in this example)
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, enter a formula that refers to the active cell
=A2+14<TODAY()
Click the Format button
On the Patterns tab, select a colour for highlighting
Click OK, click OK

There are other examples of conditional formatting here:

http://www.contextures.com/xlCondFormat03.html

 

[Frank Stone]

hi,
this site really explains conditional formating.
http://www.contextures.com/xlCondFormat01.html