Ask Your Question

Conditional formatting using text, not numbers, as the "trigger"? [closed]

asked 2017-06-26 14:40:36 +0200

appreciatethehelp gravatar image

Hello all. In a certain column of my spreadsheet, I want the background colour of the cells to go red if the cell reads "NO" and green if the cell reads "YES".

How can I make this happen?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-06-26 18:45:15.765019

1 Answer

Sort by » oldest newest most voted

answered 2017-06-26 14:49:08 +0200

erAck gravatar image

Use Cell value is with equal to and in the edit field enter "NO" including the quotation marks, choose or create a style with red background to apply. Then still for the same conditional formatting add a second condition Cell value is with equal to and enter "YES" and choose or create a style with green background to apply.

edit flag offensive delete link more


That's exactly what I tried, but neglected to add the quotation marks. Thanks.

appreciatethehelp gravatar imageappreciatethehelp ( 2017-06-26 18:40:25 +0200 )edit

Question Tools

1 follower


Asked: 2017-06-26 14:40:36 +0200

Seen: 1,830 times

Last updated: Jun 26 '17