Conditional Formatting Formula

Question

Hello,&nbsp;I am looking for a formula that meets this criteria:&nbsp;If the difference in time (H1-G1) is less than 10 minutes then highlight G1&nbsp;&nbsp;I have the rest of the spreadsheet formatted to my liking but I still manually highlight the "G" column due to not being able to create a formula to auto highlight. Any help would be much appreciated.&nbsp;Thanks,&nbsp;-Ari&nbsp;

hansvogelaar · Answer

Ari_AbsoluteAir&nbsp;
Select the entire range you want to format, and change the formula to
=$G1-$F1&lt;TIME(0,10,0)

riny_van_eekelen · Answer

Ari_AbsoluteAir&nbsp;Something like this?This is an example made on a Mac, but it's similar on PC.The CF rule would be:=$G$1-$F$1&lt;TIME(0,10,0)&nbsp;

ari_absoluteair · Answer

Riny_van_Eekelen&nbsp;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?

ari_absoluteair · Answer

THANK YOU!!!!!😊😊😊

Forum Discussion

Conditional Formatting Formula

4 Replies

Resources