Microsoft Office Forums - View Single Post - Color-fill a range of cells, based on text in a different sheet. Possible?

Thread: Color-fill a range of cells, based on text in a different sheet. Possible?

View Single Post

Old

05-31-2014, 08:01 AM

BobBridges BobBridges is offline

BobBridges is offline

BobBridges uses Windows 7 64bit

Windows 7 64bit BobBridges uses Office 2010 32bit

BobBridges uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: May 2013

Location: USA

Posts: 700

BobBridges has a spectacular aura about

BobBridges has a spectacular aura about

Default

You said one of the cells in each worksheet has the name of the color, right? So that would be the formula: Color particular cells yellow if $X$1="Yellow" (or whatever). Wouldn't that work for you?

Reply With Quote