Conditional format based on Cell header being between timeframes

[gdale]

Hi,

Been a while since I've been stumped, and I'm sure its easier than I'm making it out to be

I want to highlight the cells C2:H5 based on if the row header is within the time range A:B relative to the row of coarse

Any help would be great, i know i ts a conditional formation by formula but i cant get the formula at all.

Thank you

 

[SanjayGMusafir]

I want to highlight the cells C2:H5 based on if the row header is within the time range A:B relative to the row of coarse

Select entire range C2:H5 and use following formula to Consultation Fees -

=And(C$1>=$A2,C$1<=$B2)

Must note: Time should be formatted as time only and nothing else.