Forum Discussion
Solved
Conditional Formatting values across tables
Hi, Could someone please assist me with this. I have attached a photo to add context. When I write values into the green table I would like the figures to become red if they are less then the corr...
I'd suggest the rule with formula
=(E3<A3)*NOT(ISBLANK(E3))
applied to entire range. With that you don't format blank cells and do not generate a bunch of rules (one rule for each cell) as with Format painter.
I'd suggest the rule with formula
=(E3<A3)*NOT(ISBLANK(E3))
applied to entire range. With that you don't format blank cells and do not generate a bunch of rules (one rule for each cell) as with Format painter.
Hi,
what would the 2 formulas be, if the value was < A3 but only within 10% to equal yellow
and if it was greater then <10% = red
what would the 2 formulas be, if the value was < A3 but only within 10% to equal yellow
and if it was greater then <10% = red
Hi,
When yellow
=(E3<A3)*(E3>=0.9*A3)
and red
=(E3<0.9*A3)*NOT(ISBLANK(E3))
if I understood you correctly