automatic colour change of cells.

[codfather]

how do i get the cells to change colour once they have gone over set
parameters ie- a training schedule on a 12 month rota to automatically change
to red once it has gone over a set date and thus will show as expired/due. ta.

 

[Fluke]

Have the cells highlighted, then click on FORMAT and Conditional Formatting.
You can set your parameters in the for colour and font, and have it based on
a formula too if you want.

 

[Pete_UK]

You can use conditional formatting to do this, available on the Format
menu. Please give further details of your requirements/cells used etc
if you need further help.

Pete

 

[Sean Timmons]

If you want it to calculate based on current date, in conditional formatting,
use formula is, then

=your cell<now()-365 and format as red.

If you want to be exact on yoru dates, go to Tools > Add ins... and add the
Analysis Toolpak.

Use:

= yourcell < EDATE(now(),-12) and format.