Conditional Format Question

[Gian624]

I have a worksheet I am trying to use more than one conditional formats on. Cell A1 says 9,000 and Cell B1 says 2,000. I want the conditional format to read if cell A1 is < 10,000 then highlight it in yellow. But if Cell B1 is > 0 then also make the font red and bold.

Is it possible to have an if statement in a conditional format. The end product I would be looking for is for cell A1 to read 9,000 but be in bold red font and highlighted in yellow.

I am using excel 2010

Thank you all,
Matt

 

[Scott Huish]

Just make 2 Conditional Formats.

First one:
Conditional Formatting Formula:
=AND($A1<10000,$B1<=0)
Format with yellow background.

Second One:
Conditional Formatting Formula:
=AND($A1<10000,ISNUMBER($B1),$B1>0) Format with bold red font.

 

[Gian624]

Thank you Hotpepper!

I am a new user of 2010 and had no clue you could put a formula in for a conditional format. That is great.

I followed your post and have one problem. I was hoping to have a number 10,000 highlight and font change if B1 is greater than 0. It looks like it either highlights it or changes the font, not both. Is there a way to do both or is it an either or type of thing?

Thanks again,
Matt

 

[Scott Huish]

Sorry, I forgot to add on the second conditional format to also format the background as yellow.

 

[Gian624]

I just had a DUH moment. You were probably writing that just as I was figuring it out.

Thank you so much, this was a big help and an eye opener.