ExcelBanter - Changing Cell colour on entering data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Changing Cell colour on entering data (https://www.excelbanter.com/excel-discussion-misc-queries/222576-changing-cell-colour-entering-data.html)

Mounty

Changing Cell colour on entering data

I missed entering all the info! I have an excel sheet that I am putting
information into and when I enter in a column "Yes" and "No" I would like
them to turn green and red respectively. Is this possible in excel? Any
help would be great. Thanks

dlw

Changing Cell colour on entering data

format/conditional formatting

"Mounty" wrote:

I missed entering all the info! I have an excel sheet that I am putting
information into and when I enter in a column "Yes" and "No" I would like
them to turn green and red respectively. Is this possible in excel? Any
help would be great. Thanks

Sheeloo[_3_]

Changing Cell colour on entering data

See http://www.contextures.com/xlcondFormat01.html
if you don't know how to use Conditional Formatting...

"dlw" wrote:

format/conditional formatting

"Mounty" wrote:

I missed entering all the info! I have an excel sheet that I am putting
information into and when I enter in a column "Yes" and "No" I would like
them to turn green and red respectively. Is this possible in excel? Any
help would be great. Thanks

All times are GMT +1. The time now is 03:25 AM.