conditional formatting

  • Thread starter Thread starter hoggma
  • Start date Start date
H

hoggma

I need a formula that will highlight an entire row when the value of one cell
is true - anyone know how??
 
Suppose you want to hightlight the row if Cell in Col A contains TRUE

1. Select the rows you want to hightlight
2. Choose conditional formatting
3. Choose FORMULA IS
4. Enter the formula
=$A1=TRUE (assuming first row in selection is row 1 otherwise change one to
that row)
5. Choose the format you want
6. Click Apply/Ok and you are done
 
You do it with conditional formatting. If you can tell us which cell
(column) you are looking at we can give you exact instructions on how
to do it.

Hope this helps.

Pete
 
Back
Top