I have an excel sheet with 3 columns. the purpose of this sheet is to show the required amount of time between Departure and Arrival, and that where the 3rd column comes to picture (Duration column).
Departure, Arrival and Duration column are set as TIME cells and formatted in 24 hour .I also applied a Highlight Cells Rule on the "DURATION column" which will highlight any cell with specific time (ex. 6min or less )with any color i select.
The issue am facing is that excel is not applying the rule on all the cells but instead some cells remain the same although they fall under the rule.