Conditional formatting - Changing colour of a group of cells

[Trace]

Hi,

I have a roster in which I need to highlight 4 cells if certains times are selected.

Eg.

If

G11 = 16:00

and if

I11 = 22:00

and if

G14 = 6:00

and if

I14 = 8:00

then I want these to be the one colour.

Can anyone please help!

 

[keymaster]

@Trace,


Select all the 4 cells,

Go to CF, write this rule


=AND(G11=16:00,I11=22:00,g14=6:00,i14=8:00)


and set the color as you want.

 

[Trace]

Thank you Chandoo but unfortunately this doesn't work for me :|

Does it matter if my cells are drop down data? Or that they're in time format?

 

[NARAYANK991]

Hi Trace ,


Try using =TIME(16,00,00) , =TIME(22,00,00) , =TIME(6,00,00) and =TIME(8,00,00) in the AND formula , instead of just 16:00 , 22:00 , 6:00 and 8:00.


Narayan

 

[Trace]

No, afraid this doesn't work either :|

 

[NARAYANK991]

Hi Trace ,


I tried this on my PC and it works , if you format one cell at a time !


Select conditional formatting for G11 and enter the following formula :


=AND(G11=TIME(16,0,0),I11=TIME(22,0,0),G14=TIME(6,0,0),I14=TIME(8,0,0))


Copy the above formula for the conditional formatting in I11 , G14 and I14 individually. It works.


Narayan

 

[Trace]

Damn! That works!! Long process but at least it works!

Thank you so much!

I love this website *hugs*