Excel 2007 conditional format question
Closed
gedinfo
Posts
1
Registration date
Friday 3 June 2011
Status
Member
Last seen
3 June 2011
-
3 Jun 2011 à 17:26
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 3 Jun 2011 à 18:07
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 3 Jun 2011 à 18:07
Related:
- Excel 2007 conditional format question
- Save as pdf office 2007 - Download - Other
- How to change date format in excel - Guide
- Excel clear formatting - Guide
- Microsoft picture manager download 2007 - Download - Image viewing and management
- Excel mod apk for pc - Download - Spreadsheets
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
3 Jun 2011 à 18:07
3 Jun 2011 à 18:07
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
