K kwitt Nov 18, 2009 #1 Based on a cell value from a drop down box, how can you make a range of cells to change background color?
Based on a cell value from a drop down box, how can you make a range of cells to change background color?
S Squeaky Nov 18, 2009 #2 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
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
