Previous Topic Next Topic

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.
Related:
  • The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum
  • Tentacle locker 2 - Download - Adult games
  • Tentacle locker 1 - Download - Adult games
  • Saints row 2 cheats - Guide
  • Igi 1 - Download - Shooters
  • My cute roommate 2 - Download - Adult games

1 response

Answer 1 / 1
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

Similar discussions

The page cannot be displayed. (80710a06)
anymay -
RAY -

2 responses