Conditional Formating with a formula referencing other cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you help me again.

How would I write the formula to change the color of a cell?

=if B2= ALATAX, then make C2, background color ORANGE, if B2=CROCKER, make
C2 background color PURPLE, if B2=STATE, make C2 background color BLUE.

This color thing is boggling my mind. I'm learning but slowly. I've pull
up several items from the help - Creating conditional formatting but I'm
still confused. Would I use "MOD" ?

Thanks for your help.
 
Select cell C2, then use CF. Select the "Formula Is" option, and use the formula

=B2="ALATAX"

and set the formatting options.

Then use the Add button, and do similar formatting for the other two.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 4th Condition 3
Difference Between Dates WITH Conditional Formatting 2
Cell Formatting of a Conditional Statement 3
Format part of text in concatenated field 4
format 1
Excel conditional formatting with Weeknum 4
Conditional formatting: same color, alternate background on same r 1
Conditional formatting 2

Back
Top