View Full Version : highlight 2 consecutive cells in same Col
congokin44
03-26-2010, 11:59 PM
i have a set of strings and numbers in ColA. I would like a macro that will only color in red if 2 consecutives cells have the same number or string. ie, if a10=5 & a11=5 then highlight rows a10 & a11 in red
Bob Phillips
03-27-2010, 03:54 AM
Select A2 down and add conditional formatting with a formula of
=AND(ISNUMBER(A2),OR(A1=A2,A2=A3))
hardlife
03-27-2010, 04:17 AM
Hi You can also use conditional formating :hi:
have a nice day, Pavel
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.