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

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