Conditional formating

cogswel__cogs

Board Regular
Joined
Jan 3, 2018
Messages
98
I am using conditional formatting on a pivot table. But when I open a dropdown box the conditional formating does not seemed to get applied to drop down. How do I do that?

Any help is greatly appreciated.
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,465
Office Version
365
Platform
Windows
Are you trying to apply the Conditional Formatting to the choices presented in the drop-down box?
That is not how Conditional Formatting works. It is applied to the value stored in the cell (or the value returned by a formula in that cell).
A drop-down box presents different options for that cell, but until one is selected, it is NOT the value of that cell. So I don't think you can apply Conditional Formatting to the different options for that cell.
 

cogswel__cogs

Board Regular
Joined
Jan 3, 2018
Messages
98
I am using formula
= right($A5,3) = G15

It works on the Colasped rows. But when I expand using the (+), the expanded data does not have the conditional formating.
 

cogswel__cogs

Board Regular
Joined
Jan 3, 2018
Messages
98
I was able to get working. I think I was not including the total line when I was setting the format.
When I included it seems to do the dropdowns now.
Thanks for help
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,465
Office Version
365
Platform
Windows
Ah, I think I see what you were trying to do now.
Glad you got it figured out.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,685
Messages
5,470,132
Members
406,681
Latest member
sachinmasurkar

This Week's Hot Topics

Top