#1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"