View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
simon steel simon steel is offline
external usenet poster
 
Posts: 4
Default Conditional format question..

Can't seem to figure this out...

Three columns of data.

If the value in column 1 is a text string that is "N/A" I want to format
cells, for that row, in column 2 & 3 (which will be empty of text) with a
border line that runs diagonally from top left to bottom right of each cell.

SS.