View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Format Cell If Cell Not Blank

Got it backwards:

CF1: Formula is =xx<""

In article ,
JE McGimpsey wrote:

Worksheet functions can't format cells, but you could use Conditional
Formatting in the cell.

CF1: =ISBLANK(xx) (where xx = the cell to be formatted)
Format1: <borders/<box, desired color

In article ,
TonyD wrote:

Currently I have an IF statement determining if a cell is populated. I
would
like to provide formatting to that cell if it is populated. Can anyone help
figure out how to do both.