kojak43
Active Member
- Joined
- Feb 23, 2002
- Messages
- 270
I thought this was working, but I guess not.
In cell N6 I placed the following under Conditional Formating. If cell value is equal to 1, make the cell red.
I also used a formula on cells A6, B6 and C6 that said formula =If($N6,1) Turn A6,B6 and C6 red as well.
I tested it using a 1 in N6 and it worked fine. If there is no number 1 in N6, none of the cells turn red. That is exactly what I want to happen.
However, I just changed N6 to a 2, and all the cells changed red. (A6:C6 + N6)
What am I doing wrong?
In cell N6 I placed the following under Conditional Formating. If cell value is equal to 1, make the cell red.
I also used a formula on cells A6, B6 and C6 that said formula =If($N6,1) Turn A6,B6 and C6 red as well.
I tested it using a 1 in N6 and it worked fine. If there is no number 1 in N6, none of the cells turn red. That is exactly what I want to happen.
However, I just changed N6 to a 2, and all the cells changed red. (A6:C6 + N6)
What am I doing wrong?