I am trying to get a range of cells to turn a certain color based on the
value of a cell. For example, if the cell at the end of a row in column J is
between 0 and 3, then I want the row to change color to red from A4 to I 4. I
need to do this using a drop down box which I have created. All I can do with
conditional formatting is to turn the color of the box that the number is in.
I am trying to polish up a vendor evaluation spreadsheet whereas the vendors
rating number tells the user whether they are approved (green and between
8-11), use with caution (yellow and between 4-7 ) , or disapproved (red and
between 0-3).