Conditional Formatting using And in Excel?

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前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » excel

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准