Forum Discussion
Diana Delaney-Francis
Nov 13, 2018Copper Contributor
macro script conditional formatting
I'm trying to create a macro that will shade entire rows a color based on a cell value. I tried using conditional formatting but it seems to only work on my 1st rule. How do I do this for multiple ru...
Diana Delaney-Francis
Nov 14, 2018Copper Contributor
I tried recording a macro with multiple conditional formatting. The end result should be that 1st for any date in column O occurring today the entire row should be shaded red, 2nd for any date in column occurring tomorrow the entire row should be shaded orange, and 3rd any date in column occurring this week then the entire row should be shaded light blue. Everything else remains unshaded. When I look at the macro script the the 2nd and 3rd options don't record and when I try to run the macro the red shading doesn't shade the correct rows.
Diana Delaney-Francis
Nov 19, 2018Copper Contributor
Hi Excel experts, I could really use some help with this macro. Pleaseeee