If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Reclac Conditional Formatting
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? |
#2
|
|||
|
|||
Reclac Conditional Formatting
CH wrote:
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. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|