Select the entire row when you apply the conditional formatting.
--
Gary''s Student - gsnu200794
"Mally" wrote:
Hi
This will change the cell to yellow but i need to be able to change the
WHOLE row to yellow.
Kind Regards
"Don Guillett" wrote:
Select the row number at the left before doing your conditional format
--
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