Change Row Fill Color

[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!

 

[Don Guillett]

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