Hitesh_Banda
New Member
- Joined
- Jun 8, 2010
- Messages
- 25
Hi All,
I have a excel sheet which has conditional formatting in the cells N2 to P2 (and all cells below that), which changes their interior color to Red, Yellw and Green. (interior.color = 255, 65535 and 5287936 respectively)
Now I want to change the color of R2 and below cells (which can be done using a loop, thats no problem) depending on the colors of the cells N2 to P2 in following way.
1. 3+ Red- RED
2. 2+ Red- Amber
3. 3+ Amber- Amber
4. Rest- Green.
Can anyone put some light how I can change color of a cell depending on the color of other cells?
Thanks.
I have a excel sheet which has conditional formatting in the cells N2 to P2 (and all cells below that), which changes their interior color to Red, Yellw and Green. (interior.color = 255, 65535 and 5287936 respectively)
Now I want to change the color of R2 and below cells (which can be done using a loop, thats no problem) depending on the colors of the cells N2 to P2 in following way.
1. 3+ Red- RED
2. 2+ Red- Amber
3. 3+ Amber- Amber
4. Rest- Green.
Can anyone put some light how I can change color of a cell depending on the color of other cells?
Thanks.