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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to 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,141,018
Messages
5,703,757
Members
421,314
Latest member
Mooncake1

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