In excel change color of a range of cells based on a cell value

  • Thread starter Thread starter kwitt
  • Start date Start date
K

kwitt

Based on a cell value from a drop down box, how can you make a range of cells
to change background color?
 
Use the cell the box is linked to in your conditional formatting formula.
If your box is tied to, say, A1, make sure the conditional formula is like:

=$A$1="value"

value is whatever will be selected in the box.

Then set the background color.

Squeaky
 

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

Excel VBA 1
Changing Cell Color Based on Value 2
add value of cells based on the formatted fill color 3
How to Color a Cell Based on a Range of Cells with Colors 1
Formatted cell column in drop down list 1
Function for summing or counting cells based on a specified fill color 2
Excel Macro to automatically go to the right of the last colored cell 0
shading a cell or group of cells based on value 5

Back
Top