View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HeatherJ HeatherJ is offline
external usenet poster
 
Posts: 24
Default Conditional Formatting for entire row

Can I select an entire sheet and apply this? to say something like if
"total" appears in a cell in column A then apply a format to that row?

Thanks again!

"Luke M" wrote:

Select entire row(s). Conditional format - formula is:
=$A18="total"
(note the placement of the absolute reference)

Format as desired.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"HeatherJ" wrote:

I know how to use conditional formatting for a cell, but is there a way to do
conditional formatting for an entire row?

Example: if cell A18 contains the text, "total" then row 18 has a top and
bottom border.

Thanks, Heather