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

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

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

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