D
Deb
I have a spreadsheet that gets updated monthly and looks like the example below
Jan Feb march April May June
21,000 23,500 22,224 22111 20,111 25,000
I've asked this question before and have gotten great tips but each month
when refesh the pivot table it looses all the conditional formatting and I
start over again.
The conditional formatting needed is if #'s go down for three consecutive
months in a row they are highlighted in red. I need the first month of
dropped revenue example above would be March in yellow and then the second
month they've dropped would be orange (March) and then the third +
consecutive months (May) would be highlighted in red. The other problem with
information received before is that when I apply the conditional formatting
as condition 1 and then 2 and then 3, even months that have not been
consecutively down for three months are highlighted and I have to go back and
take formatting out one by one. The formatting is to only take place for 3
or more consecutive drops in a row. Any assistance with this and also tell
me how to prevent the formatting from being cleared every month when I
refresh the pivot table will be greatly appreciate. There are now over 4,000
rows in the database so the time it takes is tremendous.
Jan Feb march April May June
21,000 23,500 22,224 22111 20,111 25,000
I've asked this question before and have gotten great tips but each month
when refesh the pivot table it looses all the conditional formatting and I
start over again.
The conditional formatting needed is if #'s go down for three consecutive
months in a row they are highlighted in red. I need the first month of
dropped revenue example above would be March in yellow and then the second
month they've dropped would be orange (March) and then the third +
consecutive months (May) would be highlighted in red. The other problem with
information received before is that when I apply the conditional formatting
as condition 1 and then 2 and then 3, even months that have not been
consecutively down for three months are highlighted and I have to go back and
take formatting out one by one. The formatting is to only take place for 3
or more consecutive drops in a row. Any assistance with this and also tell
me how to prevent the formatting from being cleared every month when I
refresh the pivot table will be greatly appreciate. There are now over 4,000
rows in the database so the time it takes is tremendous.