Rows shading based on cell

[Yurov]

Hi,

I have a worksheet :

Server1 65 7 11
Server1 5 4 81
Server2 0 0
Server2 60 33 55
Server2 0 0
Server2 450 59 13
Server2 100 100 100
Server2 800 297 37
Server3 100 98 98
Server3 65 7 11
Server3 5 4 81
Server3 0 0


I would like the rows to be shaded the same color depending on what is in cell 1, So all server1 would be same color shading, and different shade for server2 and server3 would be same color as server 1, so alternate shadings to make it easier to read.

The file is generated from a script, so could be up to 40 different values in row1, also number of occurrences of value would differ as well.

Not sure where to start with this as at all, so any help would be greatly appreciated.

Thanks in advance

[José Augusto]

Hi
Can you distinguish 40 different colors? I suppose you will have advantages to use filters.
To use the other approach you must use VBA

[Richard Buttrey]

Hi,

One way would be to create a table of server names and alongside in a second column alternate the numbers 1 & 2. Name this two column range say "tbl_servers".

Then use two conditional format rules. Assuming your table of data starts in A1 then the first CF would be

Please Login or Register  to view this content.

and the second CF

Please Login or Register  to view this content.

define a different colour for each and apply to the whole table, e.g. A1:ARnn

If you want blank cells not to be coloured then use the following instead

Please Login or Register  to view this content.

ditto for the other rule

[Tony Valko]

See this...

http://www.mrexcel.com/forum/excel-q...ing-range.html

[Yurov]

Excellent, many thanks for your suggestions, i got it to work by following these instructions.

http://www.atlaspm.com/toms-tutorial...ting-by-group/

[Tony Valko]

Good deal. Thanks for the feedback!