Hi Experts,
Hopefully, I'll be done with conditional formatting after this request.
I've trying to conditionally format cells A2 through to A200 to highlight when a certain condition occurs(please see attached). Unfortunately, there is an error in my formulas.
I've tried both of the following:
=AND(F2<C2,J2<G2,G2<C2,J2<
F2,G2>F2,N2<K2,K2<G2,N2<J2,K2>J2,R2>O2,(R2-O2>(P2-R2),(O2-Q2)>(R2-O2)*1.5),V2>S2,V2>R2,S2>O2,S2>K2)
=AND(F2<C2),(J2<G2,G2<C2,J2<F2,G2>F2),(N2<K2,K2<G2,N2<J2,K2>J2),(R2>O2,(R2-O2)>(P2-R2),(O2-Q2)>(R2-O2)*1.5),(V2>S2,V2>R2,S2>O2,S2>K2)
But I keep on getting error message with my formula.
I wonder if an expert could take a look and let me know where I might be going wrong
Cheers
Carlotn
Hammerv2.xlsm
=AND(F2<C2,J2<G2,G2<C2,J2<
=AND(F2<C2,J2<G2,G2<C2,J2<