Change color of one cell based on another cell

Closed
Posts
1
Registration date
Monday October 26, 2015
Status
Member
Last seen
October 26, 2015
-
Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
-
Hi,
I am trying to create a speadsheet based on customer sales. In one cell it has "yes" or "no" to inform me on whether or not the customer is committed. In the cell Next to it is the # of days I have until this product is built. This cell counts down, and when it gets to a certain number it turns yellow and then red. But, I don't want the number of days cell to change color if it is committed(Yes) already. How do I do this? Thank you in advance!

1 reply

Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
148
Grapedrankquesha, Good afternoon.

Try to add to your formula a new condition.

Suppose:
A1 --> Cell that recieves YES or NO

=AND(A1="NO", your other condition)

Is this what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão