ExcelBanter - highlight based on criteria in string

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - highlight based on criteria in string (https://www.excelbanter.com/excel-programming/430407-highlight-based-criteria-string.html)

J.W. Aldridge

highlight based on criteria in string

data in A:G.
Times (12:00:53 AM) in column F.
Need to highlight any row (A:F) if the time in column F is greater
than 12:30:00 am.

Patrick Molloy

highlight based on criteria in string

either
(1) use conditional formatting
or
(2) use autofilter

"J.W. Aldridge" wrote in message
...
data in A:G.
Times (12:00:53 AM) in column F.
Need to highlight any row (A:F) if the time in column F is greater
than 12:30:00 am.

All times are GMT +1. The time now is 05:43 PM.