glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"cybersox" wrote in message
...
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