conditional formatting

JOONA

New member
Joined
Dec 9, 2013
Messages
27
Reaction score
0
Points
0
Can anyone help with this.

I need the following to happen.

I am trying to find out how to do the following

I have two coloums c one contains the information the other is a valadation list box. when i select from the list box I want colum c to high light the name i select from the list box but but in coloum c if the engineer is not it needs to say engineer not avalable select other engineer or contact branch.

hope this make sense
 

JOONA

New member
Joined
Dec 9, 2013
Messages
27
Reaction score
0
Points
0
2nd issue
also how to i get it to do the following in forumale.

I highlight a selection of cells and say that if this coloum contains any of these words highligh red. this is what i have tried. =$D$13:$D$26=Holiday,Vacent Area,Sick,BDE Engineer
 

vinod

New member
Joined
Jun 2, 2011
Messages
15
Reaction score
0
Points
0
Hi Joona - I didn't get your first question.
for 2nd one, just select the range of cells and go to conditional formatting>> highlight cell Rules>>Equals ----- apply this multiple time(depending upon how many items you want to search and hilight red)
 
Top