albertc30
Well-known Member
- Joined
- May 7, 2012
- Messages
- 1,091
- Office Version
- 2019
- Platform
- Windows
Hi all.
I am having some trouble doing something, in my honest opinion, very simple.
Example;
Say B13 has a value, then if B14 is empty I want to fill this in red and if B13 is empty but B14 has a value than fill in red B13.
I am using the following for B13
=AND($B$14=0) "Red"
and for B14
=AND($B$13=0)
My problem now is that if both B13 and B14 are empty I get them filled in red. I do not want this.
How do I go about doing this pleasae?
I think I need to go back to basics.
Regards,
Albert
I am having some trouble doing something, in my honest opinion, very simple.
Example;
Say B13 has a value, then if B14 is empty I want to fill this in red and if B13 is empty but B14 has a value than fill in red B13.
I am using the following for B13
=AND($B$14=0) "Red"
and for B14
=AND($B$13=0)
My problem now is that if both B13 and B14 are empty I get them filled in red. I do not want this.
How do I go about doing this pleasae?
I think I need to go back to basics.
Regards,
Albert