Conditional Formating Question

  • Thread starter Thread starter Bill McAdoo
  • Start date Start date
B

Bill McAdoo

Hi all

I have a sheet that I track jobs with. One of the
columns is labled "work status". I have applied
conditional formating to the cells in this column that if
the cell is not equal to "complete", then font color
changes to red. What I would like to do is not only
change the font color of that particular cell, but the
entire row that the cell coresponds to. Is this possible?

Any help is greatly appreciated.

Thanks!

Bill
 
Assuming your workstatus column begins at b1, highlight
the entire area, with the upper left cell being "b1". In
conditional formatting!"Formula is" box enter:
=($B1="completed")

Lance
 
Bill,

After you conditionally format the first cell (below), use the format
painter icon and copy the format to the entire row, not just the individual
cells.


=$A1="complete"


Don Pistulka
 
Back
Top