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
Hello,
I have a table in excel 2007, where column b has entries of names e.g. John, Devid, John, John, Gilbert, Devid etc. The same name may repeat more than once. I sort the table by names, and what I want is to color bunch of rows with say Devid name in cloun b with red color and next bunch of rows with next name with green color and so on so forth using only two colors.

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
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
0