Forum Discussion

wjallen14's avatar
wjallen14
Brass Contributor
May 05, 2020

I new problem

This one deals color.  And I thought it could be done in a conditioning rule but I could not get that to work.  I know it should be and if or statement.  For example column  L is blue and column M is...
Formulas and Functions
jukapil's avatar
jukapil
MCT
May 05, 2020

wjallen14 Yes this can be done. You should use Formula based color formatting.

 

* First select the first cell in C column from where you want to start highlighting and select the range in E column till you want this to apply. Suppose your first cell starts from C5 and you selected the range from C5:E100

* then open the formula conditional formatting and put this formula

=$L5="XYZ" and select your formattings and apply

 

* This will work. Here is XYZ is the value you want to keep

 

Repeat the same steps again and put the formula

 

=$M5="YZX"

 

Make sure column L or M does not contradict on same time. If it does, it will pick the first applied rule

 

  • wjallen14's avatar
    wjallen14
    Brass Contributor
    May 08, 2020

    I am sorry but I must be doing something wrong because this is what I put =$R11>"0"   for $C$11:$E$11 this should green and 

    Then $M11<0 for $C$11:$E$11 this should fill pink.  So what I do wrong

Resources