I have a column of data...A1, A2, .. A30
Each cell contains a number. If A1, A2, and A3 are less than 0.5, I want B1 to change color to Red. If either one of them is above 0.5, then no color.
Then I want A2, A3, A4. Then A3, A4, A5. so forth until I hit the last cell.
I tried doing something like A1:A3, but what happen, it acts like a Or statement, rather than And statement.
以上就是Conditional Formatting using And in Excel?的详细内容，更多请关注web前端其它相关文章！