Conditional more than one iif

  • Thread starter Thread starter JoeM
  • Start date Start date
J

JoeM

I need to conditional format based on if two cells are evaluated:

If in this row the value in column U is = “1†and the value in column M is >
“30†then row should be highlighted green

I probably should not wait til the end of the day to start a new excel
sheet...lol


Joe
 
Hi,

Try this CF formula

=AND($U1=1,$M1=30)

Select the full row before you apply it, change the 1 to the row you are in.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
No IF needed
Let's say you want this to apply to rows 2 thru 20
Select the row headers 2:20 so that the entire range is highlighted
For you Conditional Format formula use =AND($M2>30,$U2=1)
We reference cells in row 2 here because that this the first row of our
selected range
Note that the formula used in conditional formatting generally should return
TRUE or FALSE

BTW: why in your question did you but 1 and 30 in quotes. We seldom need
quotes around numbers in Excel
best wishes
 
I tried the both above but to no avail.

I want to select all the rows and if a value in column M are greater than 54
(>54) and the value in column V is = 1 then highlight the row.

Joe
 
BTW: why in your question did you but 1 and 30 in quotes. We seldom need
quotes around numbers in Excel

No particular reaason just wantd to note the values I was looking for,
probably some of MSAccess queries rubbing off on me, long day, sorry!

Joe
 
I tried the both above but to no avail.

Both solutions are the same and if you have described your problem correctly
both work.

If you select a range of rows then the number in the formula must be the top
row number of the selected range


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Maybe it's my CF formula?:
=AND($U1=1,$M1>30)


JoeM said:
BTW: why in your question did you but 1 and 30 in quotes. We seldom need
quotes around numbers in Excel

No particular reaason just wantd to note the values I was looking for,
probably some of MSAccess queries rubbing off on me, long day, sorry!

Joe
Click to expand...
 
The formula works fine, but what i am finding out is if I start my sheet at
say A45 the formula doesn't seem to get the same results, where if I start
the sheet at A1 it works fine.

Joe
 
Back
Top