Me again
So how do I do this to select more than one row at a time
e.g.
If rows A1, A4, A5, A10 etc. all contrain TRUE
"Mally" wrote:
Thanks. Got it working. Mistake at my end.
"Don Guillett" wrote:
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