View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Highlight a row yellow if a cell contains TRUE

Say we are dealing with row 1 and the cell in question is A1.

Format Conditinal Formatting... Formula is =$A$1=true
--
Gary''s Student - gsnu200794


"Mally" wrote:

How do i highlight a whole row if the answer to a formula in a cell = TRUE.

Kind Regards