Conditional Formatting with special characters

Hi romperstomper

We start work at 8:00am so it does not matter. I for got to mention in my previous post the following: If A1 is greater than or equal to 08:00am but less than 14:00pm than B1 should have a tick which is green, if cell A1 is greater than or equal to 14:00pm than B1 should have a cross which is red...

Hi

Just thought about it now..

If it's greater than 14:00 but less than 8:00am than it should be a red cross.

Hope i'm making sense

Put it this way:
The day starts at 00:00 and goes through to 24:00 (which is 00:00)
From 00:00 to 08:00 B1 = ?
From 08:00 to 14:00 B1 = tick
From 14:00 to 24:00 B1 = cross

Put this formula in B1
=LOOKUP(A1*24,{0,8,14},{"","a","r"})
and set the cell font to webdings and colour green
then use conditional formatting: if cell value is ="r" then font colour = red

If you want the cross for the morning slot, simply this:
=LOOKUP(A1*24,{0,8,14},{"r","a","r"})
(conditional format will still apply)

HTH

Thanks Cheeky Charlie and romperstomper!!!!

Both work fine!!!