On the roster sheet i would like the cell where names are inserted to automatically change color depending on what business they are from
Eg
24/10/17
B2 Employee1 (Turn Green)
25/10/17
B1 Employee 5 (Turn Orange)
my Issue is that i cant make the conditional formatting reference to an entire column on the other page (B1 through to B17 for example) without getting errors.
How would i go about this?
Kind regards,
Related:
Use conditional formatting to highlighting cells based on Name
The formula will say something like:
=if(cell_to_check="Business 1") {and format it with green}
=if(cell_to_check="Business 2") {and format it with red}
You can have multiple formulas for whole ranges if you wish.
Let us know if you get stuck!
It's kind of fun to do the impossible! -Walter Elias Disney
