conditional format multiple colours

A

atmel

Hi

I am using vlookup to place the "display" value in a different cell
but what I want to do if possible is have the cell change colour a
well ie 08:00 - 1500 (pink). I am not allowed to use VB to accomplis
this.

vlookup(B5,rota,3)

(rota)

No. Hours Display Colour

0 0 00:00 - 00:00 2
1 7 08:00 - 15:00 7
2 7 09:00 - 16:00 37
3 5 09:00 - 14:00 40
4 7 15:00 - 22:00 3
5 6 16:00 - 22:00 35
6 6 14:00 - 20:00 40
7 3 18:00 - 21:00 34
8 11 08:00 - 19:00 6
9 9 10:00 - 19:00 6

Thanks

Joh
 
B

Bob Phillips

Using conditional formatting, you can have 3 conditions, 4 if you count the
default. Looking at your data, it seems that you have strings not time, so
you would just test for that string value.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
K

Ken Wright

Bob has given you an option, but it is still in effect VBA, so if you are truly
not allowed to use it in any form then it cannot be done. You have 3 colour
possibilites with 4 if you include the default, but for any more than that you
have to use VBA.
 
Top