Forum Discussion
How to automatically change cell's background color by a formula
vividwhp , select your range without first column in it, create new conditional formatting rule as
in formula it shall be relative references starting from top left cell of the range (N5). Apply desired format, Ok, here confirm or change selection
That's all. You have only one rule to color your entire range, result is
SergeiBaklan , thank you so much for the reply, i see..........
so.......could you please quickly show me how to create the rule for this function for a entire range??
please take the below example, I attached the file as well.
thank you very very much.
vividwhp , select your range without first column in it, create new conditional formatting rule as
in formula it shall be relative references starting from top left cell of the range (N5). Apply desired format, Ok, here confirm or change selection
That's all. You have only one rule to color your entire range, result is
SergeiBaklan thank you so much you are the best!!!
vividwhp , you are welcome