Forum Discussion
Use formula to define cell address in reference
Hi, As a user that is not so experience with excel I have a fairly simple question, but I am afraid that answers is not going to belong to the same kind. My intentions are to reference a cell in a ...
When we may apply conditional formatting rules as
Formulas for rules are
Green:
=($E10<=2)*($F10<=2)+($E10=1)*($F10=3)
Red:
=($E10=5)+($E10=4)*($F10>2)+($E10=3)*($F10>3)+($E10=2)*($F10=5)
Yellow (all the rest):
=($E10>0)*($F10>0)*($E10<6)*($F10<6)Small minus is - if you change colors in matrix, rules formulas are to be updated for conditional formatting. But I guess the matrix is not so dynamic.
In general, it could be one set of formulas to color both matrix and column, or just create helper range which will indicate colors to apply by values.
SergeiBaklan Yeah, that did the trick. The Matrix will always stay the same, so there is no problem with updating formatting. Thank You guys for your time 🙂
Krzysztof_Pe , glad to help