LtCmdrData
New Member
- Joined
- Jan 24, 2018
- Messages
- 34
I'm trying to conditionally format a column based on three criteria. I'm using the AND function to evaluate three different cells in the same row and if all three are "true" then I want to conditionally format the first of those 3 cells. When I run the AND function down the side in a helper column to evaluate I get the answer I am looking for. When I try to apply the exact same formula in the Conditional Formatting Edit the Rule Description I get different results. Some of the results are correct but also it is highlighting cells it shouldn't. Can anyone shed any light on what is going wrong? I'm using Excel 2016. Thanks.