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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 3, 2011 at 06:07 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 3, 2011 at 06:07 PM
Related:
- Excel 2007 conditional format question
- Save as pdf office 2007 - Download - Other
- Excel date format dd.mm.yyyy - Guide
- Marksheet format in excel - Guide
- Format factory - Download - Other
- Kingston format utility - Download - Storage
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 3, 2011 at 06:07 PM
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
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
