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