My actual work book has to be green manually forcertain length of the row and
a1 one of the cell in it . b1 is in date with dd/mm/yyyy format + yellow
conditioned if that date is older than today. So I concern to add a condition
to b1 to make green looking at a1 as if Green.

"Arceedee" wrote:

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.