View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Mally Mally is offline
external usenet poster
 
Posts: 73
Default Highlight a row yellow if a cell contains TRUE

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