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