How to change cell color based on content

[J144]

Hi, hope someone can help me. I don't use Excel much, but I'm creating a
spreadsheet that keeps track of ticket sales for a charity I volunteer for.

Anyway, what I want to do is to make the cells stand out for those that
still owe money, either because a check is forthcoming or because they
ordered by credit card.

I want the credit card orders to show up with a different color (eg YELLOW)
than those who are fully paid.

I want the forthcoming check orders to show up in a different color (eg
RED).

So I have a column with payment type that is either Cash, Check, or Credit
Card.

I have a column that shows the total amount of their order.

I have a column that shows the total amount they have already paid.

The final column shows how much, if anything, they still owe. This is the
column I want to have different cell colors based on the above criteria.

How would I do this in Excel?

Thanks,
J

 

[Kletcho]

Look into conditional formatting in help.

 

[Kletcho]

A second note. When you do conditional formatting you will need to use
"Formula is" instead of "Cell value is with a formula somthing like
this:

=A5 = "Check"

Make sure not to use $ in the formula so that it copies well.