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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Excel Macro to automatically go to the right of the last colored cell 0
make all cells in same row match cell formatted with fill color 2
show fill color of a shaded row 3
Change cell fill color options 1
Conditionally formatting entire rows 2
Conditional Format a range based on 1 cell 1
"Fill" Conditional Formatting? 5

Back
Top