Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can I change the color of the cell when someone enter any number or character?
Select a cell where answer will be.
FormatConditional Formatting Set "Cell Value is" "equal to" and type "Yes" (without quotes) in the right text box. Select "Format" "Patterns" tab and select green. Click "Add" Repeat above and typing "No" and selecting red. Use Format Painter to distribute formatting to the other answer cells HTH Sandy wrote in message ps.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I change the color of the cell when someone enter any number or character? | New Users to Excel | |||
Using replace box to change a character into a CR (Alt-Enter char) | Excel Discussion (Misc queries) | |||
how can I enter a 21 digit number in a cell & keep it from change | Excel Discussion (Misc queries) | |||
How Can i change the Color of a Cell Based on Number Value (-/+)? | Excel Discussion (Misc queries) | |||
Change color of cell after user has input a number | Excel Discussion (Misc queries) |