Austin Lang
New Member
- Joined
- Sep 10, 2021
- Messages
- 46
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
Hey all,
I feel like this is a simple one but I am having a brain fart about it..
I have a document that has these separate conditional formatting rules.. How do I go about combining these into one? I attempted to add OR but I am falling short somewhere.
=AND($A5="Circuit 1",$AB5<1.5)
=AND($A5="Circuit 2",$AB5<1.5)
=AND($A5="Circuit 3",$AB5<1.5)
Thanks in advance.
I feel like this is a simple one but I am having a brain fart about it..
I have a document that has these separate conditional formatting rules.. How do I go about combining these into one? I attempted to add OR but I am falling short somewhere.
=AND($A5="Circuit 1",$AB5<1.5)
=AND($A5="Circuit 2",$AB5<1.5)
=AND($A5="Circuit 3",$AB5<1.5)
Thanks in advance.