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