Conditional more than one iif
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.
"JoeM" wrote:
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
|