Microsoft Excel 2013 Conditional Formatting

[areid6569]

I am trying to format the info in column H based off theInfo in column F.

I need H to highlight Red if it is 30 mins or more before the time in F and 30 mins or more later then the time in F. I need H to highlight Green if it is between 15 mins before and 0 mins before time in F and Yellow if it is between 15-30 mins before and 0 to 15 mins after time in F.

Thank you if anyone can help.

[FJCC]

This forum supports OpenOffice and LibreOffice. You will get better support for Microsoft Office on a forum dedicated to that.
As for you question, you don't seem to have a color assigned for all possibilities. I see
x <= -30: red
-30 < x <= -15: yellow
-15 < x <=0: green
0 < x <= 15: yellow
15 < x <= 30: no assignment
30 < x: red

[Villeroy]

If the cell to be formatted is a formula cell, then you can use the STYLE function: =numeric_calculation+STYLE(VLOOKUP(...)) or string_calculation &T(STYLE(VLOOKUP(...)))
It is also possible to combine conditional formatting with the STYLE function: viewtopic.php?t=77238&p=352722#p352722
And there are macros to apply more than 3 cond. formattings: viewtopic.php?f=21&t=6039 this simple one replaces the dialog wich is limited to 3 conditions with a cell range.
I used the above Python macro to produce a little stop motion movie with 200+ conditional formats: download/file.php?id=14875 The Basic macro just loops the frame counter.