Conditional Formatting Formula
Need to highlight A1 if B1 contains "1", "2", "3", or is empty.
What formula can help me do this? |
Maybe just use a formula like:
=OR(B1=1,B1=2,B1=3,B1="") (I used numbers--not text for 1, 2, and 3.) Cachod1 wrote: Need to highlight A1 if B1 contains "1", "2", "3", or is empty. What formula can help me do this? -- Dave Peterson |
All times are GMT +1. The time now is 06:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com