View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
 
Posts: 193
Default Conditional format if cell does not display a blank

In O8 the formula is:
=IF('Parts Summary'!C8=0,"",IF('Parts Summary'!A8=0,L8*S8,""))
That cell, correctly displays a value of 75.

In O9 the formula is:
=IF('Parts Summary'!C9=0,"",IF('Parts Summary'!A9=0,L9*S9,""))
That cell, correctly displays an empty cell as called for in the
formula.

I'd like to use CF to place a border around the cell that displays a
value. (The 75)

TIA for any thoughts.

Pierre