•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional Formatting when two columns are specific value
I am trying to use conditional formatting on two columns, when both columns equal 1. I'm on Excel 360 on a PC.
I have tried selecting both columns then using the AND formula: =AND($c2=1, $d2=1) and made sure the columns are formatted as numbers. But it only highlights when column C = 4 and column D = 1
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#AI formula generation techniques
#formula generator