CODEWITHSUNDEEP
vbaexcelexcel-formula
user1494042
user1494042

Reputation: 127

Coloring complete Row based on values from Columns

I need to color the complete Excel row based upon the value of a cell in column.

I have three columns (Item, Price and Status) and want to color the row if the Status value is:

Upvotes: 11

Views: 33336

Answers (1)

brettdj
brettdj

Reputation: 55682

You can use (non-VBA) conditional formatting for this

If your Status column was in column C then - having selected all the rows in the area of interest - you can use rules such as this to format the entire row based on the column C entries

=$C1="REJECTED" and pick Red
=$C1="WIP" and pick Orange etc

Change your column reference to suit

The sample below is from Excel 2010

{NB: Change your text case if necessary}

See Debra Dalgleish's site for more detail

enter image description here

Upvotes: 31

Related Questions