Need an IF statement....

  • Thread starter Thread starter TechnoGram
  • Start date Start date
T

TechnoGram

I have a worksheet with a list in a column that gives choices ....
is it possible to put an if statement somewhere within the sheet to
make the choices picked in the column with the list change color?
In other words if say in
Column C your choices were
yes, no, maybe, not at all
can you put an if statment in say Column XX
that says if the answer in c is yes then the font will show as bold
red, if no the bold blue and so on......
 
format>conditional formatting>etc

--
Don Guillett
Microsoft MVP Excel
SalesAid Software





- Show quoted text -
Click to expand...

Sorry but I do not understand.....

can you be a tad more explicit as to how i wntern this..... much
appreciated
 
@tyro: have you read a book on manners?

@TechnoGram:
What you are looking for are the so called "conditional formats"http://www..mvps.org/dmcritchie/excel/condfmt.htm
(Maybe this tutorial is a little bit too much, otherwise look it up in
google)
Oh...and please don't forget to post your version of Excel the next
time.

hth
Carlo





- Show quoted text -
Click to expand...

Thanks I am sure I will be able to go through the examples and
understand it..... as to versions well at present I work on 3 ....
2002, 2003 and 2007.......

As always there are many on this group that are extremely helpful in
pointing one in the right direction......
 
Back
Top