 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Hello,
I want to have a cell (A1) that asks a question with a simple 'YES' or 'NO' answer.
I want the answer (YES or NO) to be displayed in cell B1.
If the answer is 'NO' I would like a range of cells (A2:C2) to be shaded in GREY.
If the answer is 'YES' I would like the cells (A2:C2) to not change at all.
Can this be done?
Cheers, Jon
Conditional formatting and stick an 'IF' statement in it
Use conditional formatting for colouring your cells..... Just work through excels help files.....
There are lots of other fancier ways of doing this or adding functionality but this should get you started
Same answer
Thank you both.
OK, I am struggling, can you guys please help?
You only tried for 16 minutes max. Get back to it!
Select cells A2:C2
Format menu>Conditional Format
Select "Formula is" from drop down on LHS of dialogue box
In formula box next to it type: =$B$1="No"
Click on "Format" button on RHS to Set Format
Click "OK"
And use Data validation to give the user the option of Yes or No, and ask what the question is.