Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting Formula
Need to highlight A1 if B1 contains "1", "2", "3", or is empty.
What formula can help me do this? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting with dates formula problem. | Excel Discussion (Misc queries) | |||
Need conditional formatting formula to highlight top ten values i. | Excel Worksheet Functions | |||
=IF Statement formula or conditional formatting | Excel Worksheet Functions | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |