Applying multiple conditional formatting rules to one cell

Question

Hi there,

I need to format cell H2 to highlight the text in red bold if cell I2 is blank , and format the text as regular if cell I2= "yes"

That's no problem. It's working great.

Now, I also need to format cell H2 to highlight the text bold blue if cell I2 is blank, but cell J2="yes".

I've tried a bunch of different solutions, and I can't get the conditional formatting I want to work at all. 

It seems so simple.

Can you help me find the trick to make it work?

Thank you x infinity!

Answer 1

Hi, to do that go to new rule, use a formula in the format value box enter

=AND(I2="",J2="yes")

click on format and choose the one needed

Answer 2

I have a spreadsheet that evaluates states, and if someone enters a state such as "MD" or "MS", it would make it red. I am trying to do a conditional formatting to have acceptable states green, and non-acceptable states red. The formatting for the text won't allow multiple states under one command, so I have to enter duplicate formatting. How would I be able to do multiple states in the formula bar? For example, I want as acceptable states: WA, OR, ID, CA, NV, MT. Any other state would be non-acceptable, and the field would turn red. It's about 5,000 entries I need to do.

Answer 3

Your welcome, glad for helping and thanks for the feedback

Answer 4

Thank you. It worked. So far so good. 

You have to remember to set priorities for the conditional formatting rules, too.

This really solved my headache. 

1000 thanks~