Forum Discussion
I new problem
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
Where is it, at least in which sheet? For example, I found no one rule applied to C11 in New Wk Sht Start (04-29-20)
Replying on the post you may see this
to attach, or that could be another simplified version of editor with only small "attachment" icon at bottom left corner of Reply.