OK you never said WHICH cell so I will assume you want to color row 3 if
cell b3 =3
1. Select the row number at the left
2. formatconditional formatFORMULA is=$b$3=3format as desired.
TESTED
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Mally" wrote in message
...
How do i highlight a whole row if the answer to a formula in a cell =
TRUE.
Kind Regards