Forum Discussion
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 pink. now if you put and entry only in column L5 the cells c5:e5 should turn blue, However if you put an entry only in M5 then cells C5: E5 should turn pink is this possible?
10 Replies
As variant two rules
with formulas
=(LEN($L5)=0)*(LEN($M5)>0) and =(LEN($L5)>0)*(LEN($M5)=0)SergeiBaklan I tried that formula but for some reason it did not work: I will explain what I put in the row =(Len($L5)>0*... $C$5:$E$5 and when a figure is enter M5 THE C5:e5 SHOULD FILL IN GREEN
Then i put =(Len($M5)<0*... $C$5:$E$5 when a figure is enter in M5 the cell c5:e5 should fill with pink but it doesn't
And I have 25 rows to do what did do wrong
Could you please provide full formula you use, not only part of it. Alternatively you may open the file I attached to previous post, copy formula from it and try in your environment with necessary adjustments.
If you have 25 rows or so, please don't apply the rule row by row, i.e. to $C$5:$E$5, etc. Apply the rule to your entire range as $C$5:$E$30 or so.
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
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
