Change Row Fill Color

  • Thread starter Thread starter Chadd Bartlett
  • Start date Start date
C

Chadd Bartlett

I'm having a problem that I'm pretty sure can only be
resolved with some type of Macro. I would like to know if
it is possible to change the fill color of an entire row
when text is entered in a specific cell within that row.

For example. When "Not Received" is entered in cell C3, I
would like all of row 3 to be filled with light blue. If
something else is entered in that same cell
(e.g. "Received"), I do not want the fill color to change
at all. I know it's possible to change a single cell this
way using Conditional Formatting, but how do you apply
that to the entire row?

Any help is appreciated.

Thanks!
 
select the row buttow (the one with the number)>format>conditional
formatting>
formula is>=$C$3="Not Received">format as desired
 
Back
Top