Conditional Formating

[Guest]

Good Day;
I am somewhat new at this..... This is what I am trying to do.

I have 3 columns

A1 = 4
B1 = 3
C1 = "Over" (B1 greater thatn A1), "Full" (B1=A1) or "Short" (B1 Less than
A1).
I use the following to do the calc.
=IF(J7<I7,"Short",IF(J7>I7,"Over","Full")). This seems to work fine.
I would also like to change the background color depending on the value in C1.
Is there a way to use Conditional formating to do this?

Thanks

Chomp

 

[Bob Phillips]

See http://www.contextures.com/xlCondFormat01.html

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)