Conditional more than one iif

[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

 

[Mike H]

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.

 

[Bernard Liengme]

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

 

[JoeM]

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

 

[JoeM]

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

 

[Mike H]

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.

 

[JoeM]

Maybe it's my CF formula?:
=AND($U1=1,$M1>30)

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

 

[JoeM]

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