11

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:

  • DELIVERED (to Green)
  • REJECTED (to Red)
  • WIP (to Orange).
ashleedawg
  • 20,365
  • 9
  • 72
  • 105
user1494042
  • 127
  • 1
  • 1
  • 3

1 Answers1

31

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

brettdj
  • 54,857
  • 16
  • 114
  • 177