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