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 |
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 |
All times are GMT +1. The time now is 07:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com