I am trying to use conditional formatting to highlight blue if One field is higher than another but NOT if blank)
=AND(NOT($E7="")),$H7<$E7
this is giving me an error
If E7 is blank I do not want color but if E7 is less than H7 I do want color.
=AND(NOT($E7="")),$H7<$E7
this is giving me an error
If E7 is blank I do not want color but if E7 is less than H7 I do want color.