Set the color of grid depend on variable

R

Radoslaw Krzyzan

I'd like to set the color of cells (sheet1)

[A1...A8] -> Red
[A9...A28] -> Green
[A29...A44] -> Blue
[A45...A54] -> Red
....

based on data from sheet2

Start Stop Color
1 8 Red
9 28 Green
29 44 Blue
45 54 Red
.....




How to do it ?

--




~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Radoslaw Krzyzan , pl.communicator@radek
http://www.communicator.pl , ICQ 4336523
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
D

Don Guillett

This was cross posted so will appear in both.

--
Don Guillett
SalesAid Software
[email protected]
Frank Kabel said:
Hi
see Excel.misc

--
Regards
Frank Kabel
Frankfurt, Germany

Radoslaw Krzyzan said:
I'd like to set the color of cells (sheet1)

[A1...A8] -> Red
[A9...A28] -> Green
[A29...A44] -> Blue
[A45...A54] -> Red
...

based on data from sheet2

Start Stop Color
1 8 Red
9 28 Green
29 44 Blue
45 54 Red
....




How to do it ?

--




~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Radoslaw Krzyzan , pl.communicator@radek
http://www.communicator.pl , ICQ 4336523
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Click to expand...
Click to expand...
 
F

Frank Kabel

Hi Don
saw that just after I hit the Send Button :)

--
Regards
Frank Kabel
Frankfurt, Germany

Don Guillett said:
This was cross posted so will appear in both.

--
Don Guillett
SalesAid Software
[email protected]
Frank Kabel said:
Hi
see Excel.misc

--
Regards
Frank Kabel
Frankfurt, Germany

Radoslaw Krzyzan said:
I'd like to set the color of cells (sheet1)

[A1...A8] -> Red
[A9...A28] -> Green
[A29...A44] -> Blue
[A45...A54] -> Red
...

based on data from sheet2

Start Stop Color
1 8 Red
9 28 Green
29 44 Blue
45 54 Red
....




How to do it ?

--




~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Radoslaw Krzyzan , pl.communicator@radek
http://www.communicator.pl , ICQ 4336523
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Click to expand...
Click to expand...
Click to expand...
 
Top