ponderance
New Member
- Joined
- May 17, 2021
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
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.
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.