LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default How can I change the color of the cell when someone enter any number or character?

Hi,

I am trying to make a templet for my school project. The file has
number of questions with the answer YES and NO. If someone choose YES,
I want to change the cell background color to GREEN and if the answer
is NO, the color has to be RED.

Thank you,
Sajan

 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I change the color of the cell when someone enter any number or character? Saz New Users to Excel 6 August 14th 07 12:38 PM
Using replace box to change a character into a CR (Alt-Enter char) Excel user Excel Discussion (Misc queries) 2 June 9th 06 12:26 PM
how can I enter a 21 digit number in a cell & keep it from change alex Excel Discussion (Misc queries) 2 November 4th 05 10:24 PM
How Can i change the Color of a Cell Based on Number Value (-/+)? floydfam Excel Discussion (Misc queries) 1 September 7th 05 02:07 AM
Change color of cell after user has input a number F7772 Excel Discussion (Misc queries) 3 August 29th 05 09:20 PM


All times are GMT +1. The time now is 02:44 AM.

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

About Us

"It's about Microsoft Excel"