Formula
I am making a worksheet in excel and I have a YES NO cells. I would like to
be able to black out the cell I want to answer. Ex. if my answer is yes I would like to click on the cell and it would automatically turn black. Is that something that would be possible? could you use a "if" formula? -- ml |
Formula
formatconditional formattingcell is equal to yesformat as desired
-- Don Guillett Microsoft MVP Excel SalesAid Software "cybersox" wrote in message ... I am making a worksheet in excel and I have a YES NO cells. I would like to be able to black out the cell I want to answer. Ex. if my answer is yes I would like to click on the cell and it would automatically turn black. Is that something that would be possible? could you use a "if" formula? -- ml |
Formula
Thank you, excellent..it works great!
-- ml "Don Guillett" wrote: formatconditional formattingcell is equal to yesformat as desired -- Don Guillett Microsoft MVP Excel SalesAid Software "cybersox" wrote in message ... I am making a worksheet in excel and I have a YES NO cells. I would like to be able to black out the cell I want to answer. Ex. if my answer is yes I would like to click on the cell and it would automatically turn black. Is that something that would be possible? could you use a "if" formula? -- ml |
All times are GMT +1. The time now is 01:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com