I apologise if this has been inquired of previously, I wasn't able to
phrase my searches well enough (due largely to ignorance of Excel's
capabilities) to find anything useful on the web.
I'd like to format certain rows based on the content of a cell within
Below is a sample of row data.
052159000011 6 YOGURT,OG,WM,PLAIN 32 OZ 1 Case NO
052159004682 12 YOGURT,OG,WM,STWBRY&CREAM 6 OZ 12 Case YES
052159004668 12 YOGURT,OG,WM,VAN TRUFFLE 6 OZ 12 Case YES
052159004613 12 YOGURT,OG,WM,WLD BLUEBERY 6 OZ 1 EA NO
036638222118 6 YOGURT,PLAIN 32 OZ 1 EA NO
027434011297 1 YOHIMBE FUEL 50 CAP 1 EA YES
798311111712 1 Y-SNORE NASAL SPRAY 20 ML 1 EA YES
728229678984 12 YUKON GOLD BARBECUE 5 OZ 1 EA NO
728229678946 12 YUKON GOLD ONION & GARLIC 5 OZ 1 EA NO
When column 2 in a row matches column 5, the IF formula calculates the
value of the last row as YES. When 2 is not equal to 5, it calculates
I've found that using conditional formatting I can format one single
cell - for example, coloring the NOs as bright bold red, and the YESs as
bright bold green.
Where I'd really like to go with this is to hilight the entire row when
the value is not equal.
Any insights would be appreciated.