Solved Excel 2010 Conditional Formating IF AND Statement

May 13, 2012 at 17:23:48
Specs: Windows 7, Intel Quad 2.4GHz/8GB
Hello I'm trying to get an IF/AND statement to work in Excel 2010, I can get one or the other working but not both at the same time, I can build the if statement fine, but I can't get it to work in the Conditional Formatting

I want cell A7 to be bolded and Italics if Cell Q7 is Greater than 0 and if Cell U7 is greater than 0, and I want to be able to copy the formatting down the columns.


See More: Excel 2010 Conditional Formating IF AND Statement

Report •

May 14, 2012 at 07:21:09
✔ Best Answer
This is for Excel 2007.

1) Select your cell or Range of Cells
2) On the ribbon click Conditional Formatting
3) Click on New Rules, it’s near the bottom of the dialog box.
4) Click Use Formula to determine which cells to format.

5) Enter the formula: =AND(Q7>0,U7>0)

6) Click on the Format button
7) Select the Font Tab
8) Select your Bold & Italic
9) Click OK
10) Click OK

Conditional Formatting only requires that the formula return as TRUE
so making it:


is not necessary.

See how that works.


Report •

May 14, 2012 at 07:35:43
Thanks Mike, works perfect

Report •

Related Solutions

Ask Question