Use conditional formatting to highlighting cells based on Name [Closed]

Report
Posts
1
Registration date
Tuesday October 24, 2017
Status
Member
Last seen
October 24, 2017
-
 Blocked Profile -
Hello,

Im in the process of redesigning a roster that involves employees from a number of different contractors.

I have all employees on a seperate page seperated into columns based on the contractor.

EG
A1 - Business 1
A2 - Employee 1
A3 - Employee 2

B1 - Business 2
B2 - Employee 1
B3 - Employee 3

and so on.


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,


1 reply

OK so build the CONDITIONAL FORMULA to look for those business.

Take a look here:
https://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!