Conditional Formatting in a Macro

[ponderance]

Hello, all!

I used to have individual macros that would automatically color row background based on a cell value. It got lost a couple years ago, and I haven't been able to figure out how I did it.

These are the conditional formatting formulas I'm using. and the color it made the row background.

=$1:$65536 (I had this saved to select whole document, because lazy)

=$G1>”H*" - light red

=$N1>"PS*" - light green

=$N1>"CS*" - light green

=$AC2<1 - light grey


I've been messing with this off and on, and if I could get it working again it would save me many hours a month.

 

[ponderance]

Still looking for a solution to this. Seems like it should be so easy, but my brain is just mush.