onditional Formating - Question

J

Jay

If I want to conditionally format a whole row, depending on the contents
of just one cell in that row, can this be done?

So, let's say I have the range A1:M100

I want each individual row (A to M) to be conditionally formatted if
the value in the M cell of that row is <0.95, or >1.05 (2 different
conditions & formats)

Is this possible? Ideally without VBA, as I'm wanting to pass the
technique onto staff whose Excel knowledge, is, shall we say, limited.

Amy advice greatly appreciated.


Jay
 
B

Bob Phillips

Select all of the rows 1:100, goto CF, change Condition 1 To Formula Is, and
add a formula of =$M1<0.95, and set the format, add another condition,
change again to Formula Is and a formula of =$M1>1.05.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
J

Jay

Many thanks for the help, Bob.

This has opened my eyes somewhat to what can be done with conditional
formatting, and helped me incorporate some OR & AND criteria into my
conditions.(And absoluting the column but not the row is something that
just didn't occur to me but I can't think why :)

Most appreciated

Jason
 
Top