Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|