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.
|