Thread: How does this Conditional Format work?
View Single Post
 
Old 04-11-2014, 10:05 AM
Gary Drumm Gary Drumm is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: Mar 2012
Posts: 86
Gary Drumm is on a distinguished road
Default How does this Conditional Format work?
=((TYPE(H4)<>2)*(H4<>""))*OR(H4<$E4,H4>$G4)

I had help getting this conditional format, which highlights a cell if its' contents fall outside a min. max range on the spreadsheet.

I really don't understand how it works though.

Can someone explain it to me please?

Thanks,
Gary
Reply With Quote