Change the colour of a cell

Microsoft Microsoft excel 2007 (pc)
August 22, 2010 at 17:53:29
Specs: Windows 7

I am preparing a excel dashboard where in I need to change different colours based on other cell colours across various worksheets.

Say for example. I have a worksheet named "dashboard" with a row header "A". I have another worksheet named "1" which has 5 rows namely a,b,c,d,e respectively. a is filled with red colour b is filled with green c with Yellow d with orange using conditional formatting.

I need to change the colour of dashboard row to the max colour found in sheet "1" which is RED/Orange/Amber/green in the order of precedence.

Can I use a formula to do this conditional formatting or do I need to use a vba script. Pls. help

See More: Change the colour of a cell

August 23, 2010 at 10:57:09
Can't you just use the same conditional formatting rules on the Dashboard sheet that you use on Sheet "1"?

e.g. If a rule on Sheet "1" checks the value of certain cell and fills cell "a" with red, why not just test that same cell on the Dashboard sheet?

Report •

August 23, 2010 at 18:24:21
Hi Derby,

Thanks for the response but I cannot use the same rules on the dashboard as I used on the other sheets, As I have multiple rows on other sheet with a different colours and I need to change the colour of the dashboard based on the highest colour that I embark onto on the other sheet. For example IF I find a combination of Red/Yellow and Green od different cells on the other sheet, I need to colour the dashboard column to red.

Derby could you help on this please.

Report •
Related Solutions

Ask Question