Forum Discussion

Iron Contributor

Feb 10, 2022

Conditional formatting in Minutes

Hello Everyone,

How can I use Conditional Formatting to highlight calculations higher than 15 Minutes(Time difference column)?

Please help..??

Here is a attached file..

Book2.xlsx11 KB

Formulas and Functions

4 Replies

Juliano-Petrukio
Bronze Contributor
Feb 10, 2022
Excel
Find attached
Using:
=TIMEVALUE("00:15:00")
Solved-Conditional-Formatting-Greater-Than-15-Minutes.xlsx11 KB
- Excel
  Iron Contributor
  Feb 10, 2022
  Thank you so much sir.
OliverScheurich
Gold Contributor
Feb 10, 2022
Excel
Maybe as shown in the attached file.
Book2.xlsx10 KB
- Excel
  Iron Contributor
  Feb 10, 2022
  Thank you so much sir

Resources