Conditional format repeating numbers in list

demondave

New Member
Joined
Mar 6, 2009
Messages
10
I have a list of numbers in column e that I would like to conditionally format to change a cell fill color to red if the number within the cell is equal to the number in the cell above it.

ex.
E
1 718
2 718
3 100
4 603
5 568
6 547
7 895
8 895
9 895

The cells for E2, E8, and E9 would turn red because they match the cell above, but they others stay white. I am using excel 2007 which is new to me. So any detail is appreciated.

Dave
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

crook_101

Well-known Member
Joined
Oct 20, 2008
Messages
682
Hi,

Go to cell E2 and on the home tab click on Conditional formatting, Highlight cells rules, then Equal to.

Click on cell E1 and this will populate the equal to pop up menu with =$E$1, you need to ammend this by use of the delete/backspace key and clicking in the pop up to remove both of the $ signs to leave just =E1, you cannot use the cursors for this either:(


Once you have =E1 populated,and the fill colour selcted hit OK.

CLick on cell E2 and double click on the format painter tool on the Home tab, Click on cell E3 and drag it dwn to the botom of your selection.

Job done.

HTH

Ian
 

Forum statistics

Threads
1,176,367
Messages
5,902,732
Members
434,990
Latest member
Peter Jeffrey Gale

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top