conditional formatting
 

I need a formula that will highlight an entire row when the value of one cell
is true - anyone know how??
--
hoggma

conditional formatting
 

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


"hoggma" wrote:

I need a formula that will highlight an entire row when the value of one cell
is true - anyone know how??
--
hoggma

conditional formatting
 

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

On Jan 7, 5:21*pm, hoggma wrote:
I need a formula that will highlight an entire row when the value of one cell
is true - anyone know how??
--
hoggma