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.


"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
>

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"JoeM" <(E-Mail Removed)> wrote in message
news:2580D65E-01CE-4795-ADD5-(E-Mail Removed)...
> 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
>

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


"Bernard Liengme" wrote:

> 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
> --
> Bernard Liengme
> Microsoft Excel MVP
> http://people.stfx.ca/bliengme
>
> "JoeM" <(E-Mail Removed)> wrote in message
> news:2580D65E-01CE-4795-ADD5-(E-Mail Removed)...
> > 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
> >
> .
>

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

"Bernard Liengme" wrote:

> 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
> --
> Bernard Liengme
> Microsoft Excel MVP
> http://people.stfx.ca/bliengme
>
> "JoeM" <(E-Mail Removed)> wrote in message
> news:2580D65E-01CE-4795-ADD5-(E-Mail Removed)...
> > 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
> >
> .
>

> 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" wrote:

> 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
>
>
> "Bernard Liengme" wrote:
>
> > 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
> > --
> > Bernard Liengme
> > Microsoft Excel MVP
> > http://people.stfx.ca/bliengme
> >
> > "JoeM" <(E-Mail Removed)> wrote in message
> > news:2580D65E-01CE-4795-ADD5-(E-Mail Removed)...
> > > 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
> > >
> > .
> >

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


"JoeM" wrote:

> 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
>
> "Bernard Liengme" wrote:
>
> > 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
> > --
> > Bernard Liengme
> > Microsoft Excel MVP
> > http://people.stfx.ca/bliengme
> >
> > "JoeM" <(E-Mail Removed)> wrote in message
> > news:2580D65E-01CE-4795-ADD5-(E-Mail Removed)...
> > > 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
> > >
> > .
> >

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

"JoeM" wrote:

> Maybe it's my CF formula?:
> =AND($U1=1,$M1>30)
>
>
> "JoeM" wrote:
>
> > 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
> >
> > "Bernard Liengme" wrote:
> >
> > > 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
> > > --
> > > Bernard Liengme
> > > Microsoft Excel MVP
> > > http://people.stfx.ca/bliengme
> > >
> > > "JoeM" <(E-Mail Removed)> wrote in message
> > > news:2580D65E-01CE-4795-ADD5-(E-Mail Removed)...
> > > > 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
> > > >
> > > .
> > >