Reclac Conditional Formatting

[CH]

I have a template that uses conditional formatting to hide selection boxes
based on certain selections that are made within the workbook (note:
selection boxes are drop down lists fed by using the data vaildation
function). An example of this would be...if diversity is selected in Cell A1,
then I need the drop down list in cell c1 to be hidden).

I can set up the conditional formatting for this with no problem...however,
when a new selection is made (something ither than diversity) the conditional
formatting does not update until I click in a different cell (like it not
automattically recalulating the conditional formatting as needed).

Any thoughts on how to fix this?

 

[Marshall Barton]

I have a template that uses conditional formatting to hide selection boxes
based on certain selections that are made within the workbook (note:
selection boxes are drop down lists fed by using the data vaildation
function). An example of this would be...if diversity is selected in Cell A1,
then I need the drop down list in cell c1 to be hidden).

I can set up the conditional formatting for this with no problem...however,
when a new selection is made (something ither than diversity) the conditional
formatting does not update until I click in a different cell (like it not
automattically recalulating the conditional formatting as needed).

This newsgroup is for questions about using queries in
Access database systems. You should repost your question in
a forum dedicated to whatever spreadsheet program you are
using.