經安全檢測,此網站為安全網站,請放心前往原始網址!

excel - Change background color of the row or range if a particular cell value is equal to some text

What I have: 1 Col A Col B Col C Col D Col E Col F 2 3 Approved Text Text Text Text Text 4 Reject Text Text Text Text Text 5 Pending Text Text ... ... Based on Excel 2007: Ie in Conditional Formatting create three separate rules, each with a formula like

stackoverflow.com

網址安全性掃描由 google 提供