Not sure what I am doing wrong here but when I entered the formula as typed,
it changed the whole range that I wanted to apply the formatting to red, and
I had nothing in the drop down box. Think I need to clear the "pick from drop
down list" out of the spread sheet first?
--
Nothing is foolproof to the sufficiently trained and motivated fool.


"Sheeloo" wrote:

So you want to highlight the row if cell in Col J for that row is between 0
and 3?

Suppose your data is in A1:J100 then select the whole range
in the conditional formatting dialog choose FORMULA IS and enter this
following
=AND($J1=0,$J1<=3)
and choose the format you want...
(note the $ in front of J and its absence in front of 1... this changes the
condition to J2 for row two but keeps it J1 for row1

Change it to if do not want to include 0 and 3
=AND($J10,$J1<3)

"rigid_40" wrote:

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).