Need to highlight A1 if B1 contains "1", "2", "3", or is empty.
What formula can help me do this?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks