Conditonal formating of rows
Closed
Anant
-
Feb 14, 2010 at 03:52 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 14, 2010 at 09:03 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 14, 2010 at 09:03 AM
Related:
- Conditonal formating of rows
- How to delete rows and columns in word - Guide
- Format of marksheet in excel - Guide
- Excel insert multiple rows - Guide
- Change the format of the selected cell to the mm-dd-yy date format - Guide
- Repeat rows in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 14, 2010 at 09:03 AM
Feb 14, 2010 at 09:03 AM
01. Click on "HOME" tab
02. Select the rows
03. Click on Conditional Formatting
04. Click on Manage Rules
05. Click on New Rules
06. Select "Use a formula to determine which cells to format"
07. write =AND($B2=$B1)
08. Click on format and choose green color and click OK
09. Click OK
10. Click on New Rules
11. Select "Use a formula to determine which cells to format"
12. write =$B2<>$B1
13. Click on format and choose red color and click OK
14. Click Apply
15. Click OK
02. Select the rows
03. Click on Conditional Formatting
04. Click on Manage Rules
05. Click on New Rules
06. Select "Use a formula to determine which cells to format"
07. write =AND($B2=$B1)
08. Click on format and choose green color and click OK
09. Click OK
10. Click on New Rules
11. Select "Use a formula to determine which cells to format"
12. write =$B2<>$B1
13. Click on format and choose red color and click OK
14. Click Apply
15. Click OK