I got a spread sheet with time data that I need to conditionally validate. The column looks like this ;
TIME
6:00 AM
6:13 AM
6:36 AM
6:45 AM
7:00 AM
7:13 AM
All the
Way
down to
5:00 PM

What I need is to turn RED BOLD the time frames 6:30 AM 9:00 AM, 12:00 PM, 2:45 PM , now the data entry for these time values are not going to fall in the exact times, so what I need to do is turn red bold the closes next up values red bold. I try to use conditionally validation, but it only let me do only 3.
How can I conditionally validate this set of 4 time frames? Can an expression do it? Function? If Statement? ….Any orientation is well appreciated . I posted this question on the Programming Forum, but didn’t had any input, that is the reason I’m posting here now.