automatic colour change of cells.

  • Thread starter Thread starter codfather
  • Start date Start date
C

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.
 
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.
 
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
 
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.
 
Back
Top