Hi All,
I need some help on how to accomplish the following:
I would like to assign a background color to Cell G7 based on a condition from Cell F7…
Normally I would do this with the Conditional Formatting, but I can only enter the formula 3 times due to Excel limitation under Conditional Formatting….
I need to select up to 10 different colors
Example;
=IF(F7,1) then G7 background turns red
=IF(F7,2) then G7 background turns green
=If(F7,3) then G7 background turns yellow
and so on at least up to 10.
Any help would be greatly appreciated.
Best Regards.
I need some help on how to accomplish the following:
I would like to assign a background color to Cell G7 based on a condition from Cell F7…
Normally I would do this with the Conditional Formatting, but I can only enter the formula 3 times due to Excel limitation under Conditional Formatting….
I need to select up to 10 different colors
Example;
=IF(F7,1) then G7 background turns red
=IF(F7,2) then G7 background turns green
=If(F7,3) then G7 background turns yellow
and so on at least up to 10.
Any help would be greatly appreciated.
Best Regards.