Trying to do conditional formatting based on text value in column B containing and if column F is greater then 1 minute 30 seconds.
This is what I have but it's not formatting the colour to the row.
=AND($B2="ACW", $F2>"00:01:30")
Basically looking for check column F for greater then 1minute 30 seconds and highlight the row if Column B says ACW.
Bookmarks