Hi Sharon,

Tricky formula situation here....
I wanted to change cell colour when certain cells of the workbook are filled
in...I have formatted cells to become yellow when they are Not Blank, but
cant seem to figure out a formula which works with cell formatting? Im on
2007....

Date Notified Name First day Last day EMP1 Received Med 3/5
Received Reason Blue Sal to payroll Green sal to payroll Comments. Complete
RTWI Sent to Manager
04/04/10 Blah Blah 12/04/10 12/04/10 12/04/10 Fell
over 12/04/10 12/04/10 12/04/10










As is, the yellow is perfect, but as I go along the process and enter a date
in the €˜Blue sal to Payroll cell I would like the entire filled cells to
become blue. Again when filling in the €˜Green Sal to payroll for all cells
to go Green etc etc...its overlaying I know, but it would be great if I could
get it to work.

Any suggestions?

--
Thank you for reading my post. Hopefully you can answer my querie