richardial
New Member
- Joined
- Jun 1, 2007
- Messages
- 8
Hi,
I have a spreadsheet with values in column A ranging from 1-6. I would like to set each row colour depending on the value in cell A. Is there a formula or any VBA I can use to do this?
For example:
if cell a2 = 1, color row to green.
if cell a3 = 2, color row to blue.
if cell a4 = 3 colour row to pink.
if cell a5 = 4, color row to yellow.
if cell a6 = 5 colour row to grey.
if cell a7 = 6 colour row to orange.
I have a spreadsheet with values in column A ranging from 1-6. I would like to set each row colour depending on the value in cell A. Is there a formula or any VBA I can use to do this?
For example:
if cell a2 = 1, color row to green.
if cell a3 = 2, color row to blue.
if cell a4 = 3 colour row to pink.
if cell a5 = 4, color row to yellow.
if cell a6 = 5 colour row to grey.
if cell a7 = 6 colour row to orange.