View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bgl bgl is offline
external usenet poster
 
Posts: 1
Default Conditional formating a row

If a specific condition is met for a cell in a column and I format that cell,
how can I make the entire row that has that condition met have the same
format.
For example: Column has name, other column has amount.

if the amount is negative, I know how to make it bold, red; but, how can I
also make the customer's name bold, red ?