Forum Discussion
Conditional Formatting Formula
Hello, I am looking for a formula that meets this criteria: If the difference in time (H1-G1) is less than 10 minutes then highlight G1 I have the rest of the spreadsheet formatted to my...
Riny_van_Eekelen thank you, one last question...is there a way to easily apply that to a section and not just one row at a time by duplication?
Select the entire range you want to format, and change the formula to
=$G1-$F1<TIME(0,10,0)- THANK YOU!!!!!😊😊😊