conditional formatting based on the value of another cell

  • Thread starter Thread starter bwilde
  • Start date Start date
B

bwilde

I want to apply a conditional format to a cell based on the value of another
cell having nothing to do with the value of the cell I want the format to
effect. for example - if the value in cell m5<0 i want cell a5 to be italic
(regardless of the value in a5)
 
You need to use the CF/ Formula Is ... option, rather than CF/ Cell Value Is
....
then you can use Formula Is =M5<0
 
thank you - would you also know how I can have more than one condition - I
want to say if m22<=0 OR r22<=0 OR x22<=0 format green - I'm doing something
wrong
 
Perhaps you haven't looked at the Excel help for the OR function?
That will tell you the syntax of the function.
 
I did and I still can't seem to get it right. when i use OR either I get an
error or if I don't get and error the CF doesn't work
 
If I put = M22<0 OR =R22<0 OR =X22<0 I get an error. If I put (= M22<0) OR
(=R22<0) OR(=X22<0) it changes it to ='(= M22<0) OR (=R22<0) OR(=X22<0)' and
there's no error but it doesn't work.
 
Back
Top