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