Change color of one cell based on another cell

Closed
Grapedrankquesha Posts 1 Registration date Monday October 26, 2015 Status Member Last seen October 26, 2015 - Oct 26, 2015 at 10:13 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 26, 2015 at 11:59 AM
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 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Oct 26, 2015 at 11:59 AM
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
1