How to have row color change based on one cell to 4 colors

  • Thread starter Thread starter Mel
  • Start date Start date
M

Mel

I have a spreadsheet that will have up to 20,000 lines on it.
A1:K20000. Cell I2 is the cell that I use for the line color.
It will have 4 possible options. 'I', "H", "O", "C".
(Would like to use a drop down list if that would work with the line
formatting.)

H=Red (#40), O=pale yellow(36), I=green, C=light blue

I know I cannot use conditional formatting as I have 4 colors.
Not exactly sure how to write up the code for this one.
Any help would be most appreciated.
thx

Mel
 
set the cells to one of those colours by default, then use CF on the other 3
values/colours.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter rows data based on background color of individual cells 1
Have row color change to one of 8 different colors based on one cell's value (I, O, C, T, L, E, X, A 8
Color row based on cell value 1
Changing cell colors 1
Conditional format color change 2
Formula to set cell color 3
Counting the number of rows based on the color 2
Recognize Cell Color and Sum Data accordingly 3

Back
Top