Thanks Pete that was helpful, in my case i am changing the cells color
based on the result of a formula that comes from another sheet, i.e I
have formula which gives an alphabet result into a named range in
another sheet, The color change is based on result of that from
another named range in another sheet. I have tried the code given by
you but looks like it works fine for manual entries but doesn't work
for formulas Can you please guide me on that I am new to VBA.