Using Conditional Format

[JakeMann]

Hi All,

I want to highlight a cell with conditional format. I understand the method but I can't apply the formula!

In cell i30 is "mat in stock"
In cell G30 is "0"

I want a formula that says if cell i30 = "mat in stock" and cell G30 = "0" then highlight the cell.

I was trying =IF(OR(i30="mat in stock",G30="0"),"") but it doesn't work.

Any ideas?

[Fotis1991]

Try In CF rules

Please Login or Register  to view this content.

How can you use Conditional Formating.

--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.

[ARGK]

Hi
change your formula to this:

=AND(I30="mat in stock",G30=0)

Good luck.
Tony

[JakeMann]

Brilliant, thanks guys. Works a treat.