I'm trying to apply conditional formatting across this entire sheet to highlight three consecutive cells above 4.5.
I thought I had it with = and(e3>4.5,f3>4.5,g3>4.5)
it doesn't work. I've tried a couple of different formulas and it always highlights pieces rather than the three or more in a row that are above the 4.5 constant
help please! I'm sure someone here can get it.. I sure couldn't..