I have a large spreadsheet with 14 different conditional formatting rules. I'm tired of having to weed them out everytime I blink. If I did it with VBA would it eliminate that problem? If so I would like to do that. I can likely figure out how to set up most if not all of them once I have one.


I'll just list what I have so you can see how complicated, or not, they are. I don't think they are complicated but since I clearly am VBA clueless how would I know.

=$M3="p" Applies To =$A$3:$EZ$30000
=$C3>$C2
Applies To =$A$3:$EZ$30000
=AND($N3<>0,$N3<>"",$M3<>"co",$M3<>"p",$M3<>"f",$M3<>"m",$M3<>"sf",$M3<>"cp",$M3<>"of",$M3<>"o",$M3<>"upd",$M3<>"ypd")
Applies To =$A$3:$EZ$30000
=AND(OR($M3="f",$M3="m"),OR(ISBLANK($O3),ISBLANK($AP3)))
Applies To =$A$3:$EZ$30000
=$M3="D"
Applies To =$A$3:$EZ$30000
=AND(OR($A3<>0,$B3<>0),$L3="D")
Applies To =$A$3:$EZ$30000
=OR(ISBLANK($L3),$L3="D",$L3="u",$L3="y",$L3="M",$L3="WE",$M3="f",$M3="m",$M3="sf",$M3="of")
Applies To =$A$3:$EZ$30000
=AND($L3="u",$O3>0,ISBLANK($AP3),$CL3=0,$CL3<>"")
Applies To =$A$3:$EZ$30000
=AND($L3="y",$O3>0,ISBLANK($AP3),$DK3=0,$DK3<>"")
Applies To =$A$3:$EZ$30000
=OR(AG3<0,AND(AG3>$AG$1,AG3<>""))
Applies To =$AG$3,$AL$30026
=$AB3-$AB2>50000
Applies To =$Ab$3:$AB$30000
=OR($L3="y",$M3="ypd",AND($M3="co",$M2="ypd"))=OR($L3="u",$M3="upd",AND($M3="co",$M2="upd"))
Applies To =$A$3:$EZ$30000