Forum Discussion
I new problem
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.
SergeiBaklan i am trying to attach my spread sheet so you can see but i do not see how