How can I change the color of the cell when someone enter any numb
On Aug 13, 8:54 am, Ron Coderre
wrote:
Try this:
Select the range of input cells
From the Excel main menu:
<format<conditional formatting
Condition_1
Cell value is: equal to: Yes
Click the [format] buttton....set the color....click [OK]
Click the [Add] button
Condition_2
Cell value is: equal to: No
Click the [format] buttton....set the color....click [OK]
Click [OK]
Does that help?
***********
Regards,
Ron
XL2003, WinXP
Thank you guys for your PRICELESS help...............man this is my first time browsing in this site and I LOVE IT. =)
"Saz" wrote:
Hi... =) I am trying to build a templete with a list of questions
where the users will answer YES or NO. Please help me to change the
color of the cell to Green if they answer yes, and Red if they answer
no.
Thank you,
Sajan- Hide quoted text -
- Show quoted text -
|