You don't say how you colour a1. What entries are you making in b1 for cond
format to take effect?

"narnimar" wrote:

I do color indication in cell a1 once I finished a perticular job as Green.
My Cell b1 has conditionally formatted already for yellow if job is started.
Now once a1 is Green I want b1 also has to be Green. How can I do that in
excel 2007? Thank you in advance for any help.