Forum Discussion
Solved
Conditional formatting help
Hi there. I'm looking for some help please. I am using a data set and have put this into a pivot table. I was to use conditional formatting to highlight when a particular cell is higher, lower, o...
Select E6:E50 or however far down the data extend.
E6 should be the active cell in the selection.
When you create the conditional formatting rule, make sure that you refer to D6, and not to D$6 or $D$6.
Select E6:E50 or however far down the data extend.
E6 should be the active cell in the selection.
When you create the conditional formatting rule, make sure that you refer to D6, and not to D$6 or $D$6.
