Conditional format if cell does not display a blank

P

Pierre

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
 
G

Gord Dibben

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

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

Note: the relative cell reference for O8.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula setting cell type to blank and conditional formatting 6
Summing a range of cells based on criteria in another range 2
# Value error and how to ignore blank cells 2
Sum or Average with #N/A cells 5
return blank cell if condition met 2
SUM cells with blank value 10
Conditional Formatting using Small 1
Min+Max from other Tabs 4

Top