automatic colour change of cells.
 

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.
--
ob1kinob

automatic colour change of cells.
 

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.

"codfather" wrote:

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.
--
ob1kinob

automatic colour change of cells.
 

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

On May 22, 2:18*pm, codfather
wrote:
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.
--
ob1kinob

automatic colour change of cells.
 

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.

"codfather" wrote:

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.
--
ob1kinob