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

Conditional format if cell does not display a blank
 

Select the cells to format then.............

FormatCFFormula is: =O8<"" Format to a border and OK your way out.

Note: the relative cell reference for O8.


Gord Dibben MS Excel MVP


On 17 Oct 2007 13:18:41 -0700, Pierre wrote:

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