conditional formatting using IF with times

[zman36]

I have a program using conditional formatting to color cells yellow green or brown based upon whether or not an aircraft is pending flight, in the air or landed respectively.

ex: take off time 1200 landing time 1400(times must be in Zulu) current time 1100 row is yellow. This works fine with the coding I have.

Where i'm running into the problem is say an aircraft is taking off at 2200Z(6pm) and landing at 0400Z(12am) the formula sees the landing time as "smaller" than the take off time therefore thinking it to be grounded and colroing it browm. the conditional formula i'm using is: =IF($C$2>=$F$7, $C$2<$H$7) where C2 is the current time, F7 is the takeoff time, and H7 is the landing time. That Formula is to shade the row green denoting the aircraft is in the air. I have 2 more for the other conditions. is there anyway to put formulas in conditional that have if the IF statement is false then do.... ? I appreciate the help thanks.

[arthurbr]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!