ExcelBanter - In Excel - I want cell to turn green when enter Yes & Red for no?

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

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

- - In Excel - I want cell to turn green when enter Yes & Red for no? (https://www.excelbanter.com/excel-discussion-misc-queries/222573-excel-i-want-cell-turn-green-when-enter-yes-red-no.html)

Mounty

In Excel - I want cell to turn green when enter Yes & Red for no?

Bob I

In Excel - I want cell to turn green when enter Yes & Red forno?

Please see Conditional Formatting in Excel Help.

Mounty wrote:

All times are GMT +1. The time now is 07:58 PM.