Forum Discussion
Conditional Formatting Rules
Hello, Is someone able to advise if it is possible to add a rule whereby the below (V & W) Column boxes are only highlighted when a selection has been made on a previous dropdown? Is there a way I c...
See attached. Note that I removed the trailing space you had in "Table P " in the dropdown list.
Thank you so much for this, any idea how i can do it so it works for the whole columns? It only works for row 4 at the moment. Thanks again
On the Home tab of the ribbon, select Conditional Formatting > Manage Rules...
Select 'This Worksheet' from the 'Show formatting rules for' drop-down.
You'll see:
Edit the 'Applies to' range for both rules:
- Thank you both I've now managed to include all columns.
Is it possible for me to change the rule so the columns do the opposite, as in they are initially greyed out but become available when the drop down is selected? Currently they appear greyed out when the option is selected. Hope that makes senseSee the attached version. I created 2 rules for V3:V10000 and 2 rules for W3:W10000.
