Hi everyone,

I am working on a spreadsheet for financial data which is based on forecast and actual data. As it's the start of our financial year we don't have any actual data yet so all figures in all the 'actual' rows match the dummy forecast data.

Dummy sheet.xls

What I'm wondering is if there's a way to do the following:

If I choose 'actual' from the list at C3, D3, etc instead of 'forecast', is there a way to set it up so that it changes the text colour (or fill colour) of the corresponding actual data at C9, C15, C21, C27 and C33? ie. so that it's clear by colour when data is 'actual' and when it is 'forecast'?

FYI I'm using Excel 2007 but a lot of others use 2003 so it needs to be as compatible as possible.

Any help is greatly appreciated!