Worksheet problem in excel 2003

[Closed]
Report
Posts
1
Registration date
Monday November 25, 2013
Status
Member
Last seen
November 25, 2013
-
Posts
2807
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 21, 2021
-
I have a worksheet that I have a yes,no drop down menu. I then have 4 cells below that, that currently have conditional formatting to them that change them to red when Yes is selected in the above drop down box. The red in the 4 cells tells the person that is filling out the worksheet that because you entered yes on above question you now have to fill in the information that is now needed below. Now as they answer the questions to the 4 cells below as the cells get value put in them I would like them to turn to white after the question is answered. Also I would also like to have code written that if yes is answered and the person that is filling out sheet fails to put a value in each cell the questions error msgs saying you forgot to enter the answer question # 4 or so on and so on. Help me I have been struggling

1 reply

Posts
2807
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 21, 2021
482
Hi Hairs,

Let's say Yes/No question is in A1, the other 4 cells are A2:A5.

Apply conditional format for A2:A5.
First rule: =AND($A$2<>"",$A$3<>"",$A$4<>"",$A$5<>"") Format: No color
Second rule: =$A$1="Yes" Format: Red

Now A2:A5 will turn red if Yes is in A1 but only if there is at least one empty cell in range A2:A5.

If this doesn't entirely solve your query, then please re-explain in detail with an example.

Best regards,
Trowa