Excel 2007 conditional format question

Closed
gedinfo Posts 1 Registration date Friday June 3, 2011 Status Member Last seen June 3, 2011 - Jun 3, 2011 at 05:26 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 3, 2011 at 06:07 PM
Hello,

I have an excel 2007 file which I wish to be able to highlight a row if the first two cells in that row equal "Large code model" in the first cell and the second cell equals "X".

How do I do this?

thank you.

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 3, 2011 at 06:07 PM
1. Click on the first Cell row 1 (A1)
2. Select All the rows till which you want conditional format (or all rows)
3. Click on conditional formatting
4. Click on "Use a Formula ....
5. Enter formula
=and($a1="Large code model", $B1="X")
6. Chose the color that you would like to use
0