View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Conditional Formatting with the cell above

I need to know how to set a conditional format for "the cell directly above"
instead of specifying a specific cell.

I highlight the cell i want to format, i click on conditional format, i
choose cell value is then I choose equal to then I want to choose "the cell
above" so i can copy it down the column. Does anyone know how to enter "the
cell above?"