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
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!
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!
Related:
- Change color of one cell based on another cell
- Notepad++ change background color - Guide
- Change name of lg tv - Guide
- How to change number of best friends on snapchat - Guide
- Change computer name cmd - Guide
- Sound card color code - Guide
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
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
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
