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
|