Formula

  • Thread starter Thread starter cybersox
  • Start date Start date
C

cybersox

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?
 
Thank you, excellent..it works great!
--
ml


Don Guillett said:
format>conditional formatting>cell is equal to yes>format as desired

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Click to expand...
 
Back
Top