Conditional Formatting Rules

Question

Hello,Is someone able to advise if it is possible to add a rule whereby the below (V &amp; W) Column boxes are only highlighted when a selection has been made on a previous dropdown? Is there a way I can grey the box out or similar?&nbsp;I can do basic conditional formatting but unsure if this falls into it.&nbsp;Thank you in advance&nbsp;&nbsp;

riny_van_eekelen · Answer

JoshuaHughes1&nbsp;See attached. Note that I removed the trailing space you had in "Table P " in the dropdown list.&nbsp;

joshuahughes1 · Answer

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

hansvogelaar · Answer

JoshuaHughes1&nbsp;
On the Home tab of the ribbon, select Conditional Formatting &gt; Manage Rules...
Select 'This Worksheet' from the 'Show formatting rules for' drop-down.
You'll see:

Edit the 'Applies to' range for both rules:

&nbsp;

joshuahughes1 · Answer

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 sense

hansvogelaar · Answer

JoshuaHughes1&nbsp;
See the attached version. I created 2 rules for V3:V10000 and 2 rules for W3:W10000.

Forum Discussion

Conditional Formatting Rules

Share

Resources