color change for matching value cells

I have 2 cells that IF they DO NOT match numerically I want them to change fill color (a warning flag), I know it's done through conditional formatting but I can only find how to do it with matching cells. Any help would be appreciated.

Which are the two cells? We can't give you a formula if we don't know which cells it should refer to. Attach a sample workbook (the FAQ describes how to).

Pete

Select cell I10, then click on Conditional Formatting | New Rule | Use a formula... , then put this formula in the box:

=$I$10<>$I$12

Click the Format button | Fill tab and choose red, then click OK twice to exit. You can use the Format Painter icon to copy the format from I10 into I12 if you want both cells to show red.

Hope this helps.

Pete

Originally Posted by Pete_UK

Select cell I10, then click on Conditional Formatting | New Rule | Use a formula... , then put this formula in the box:

=$I$10<>$I$12

Click the Format button | Fill tab and choose red, then click OK twice to exit. You can use the Format Painter icon to copy the format from I10 into I12 if you want both cells to show red.

Hope this helps.

Pete

Thank you Pete