Forum Discussion
Solved
Highlighting Content
Hello, not sure how to word my request. But here we go What I am trying to do: I have a pivot table open. With row values that correspond to the month it is needed. Then in column M I have what our ...
B1:J1 contains abbreviated months, while M2:M1068 contains the full month names.
Enter =TEXT(L2,"mmm") in M2, then fill down.
One question and it is probably extremely simple to answer.
How do I get this rule to work for all the months? The way you have it populated only highlights data with the month May. I want it to highlight every month specific to where the first data falls.
1) In row C2 it highlighted it properly because it hit in May.
2) How do I get cell's to highlight if they're specific to April, June, July....... So on and so forth?
How do I get this rule to work for all the months? The way you have it populated only highlights data with the month May. I want it to highlight every month specific to where the first data falls.
1) In row C2 it highlighted it properly because it hit in May.
2) How do I get cell's to highlight if they're specific to April, June, July....... So on and so forth?
Adding additional request.
How would I make sure it is only selecting data that has values? I don't want anything blank to highlight.
So for row 2&3. I want only cell C2 to highlight
For row 4 & 5 I'd only want cell B4 to highlight
For ones that are specific to June I'd only want June to highlight if there is a numerical value there.
How would I make sure it is only selecting data that has values? I don't want anything blank to highlight.
So for row 2&3. I want only cell C2 to highlight
For row 4 & 5 I'd only want cell B4 to highlight
For ones that are specific to June I'd only want June to highlight if there is a numerical value there.
1) In my first reply, I wrote that you should select B2:J50 (or further down). This will take care of all months from May to December.
2) Change the formula in the rule to
=AND(B$1=$M2, B2<>"")
HansVogelaar This did not work. The formula's are still giving me the same errors as before. I have attached within a preview of the conditional formats and as much of the worksheet as I can.
Delete the second rule - the top rule is its replacement!