blank cell conditionally formatted

[davegb]

I would like blank cells in my spreadsheet to be white (no shading). I
would like the cells with text to be formatted to a selected color. I
did a search in this NG but couldn't find any similar situations. Does
anyone know how to do this?

TIA

 

[JE McGimpsey]

One way:

Format your cells as white (no shading). Select the cells to
Conditionally format (with, say, cell A1 the active cell), and set the
dropdowns and inputbox to read

CF1: Formula is =LEN(A1)>0
Format1: <patterns>/<selected color>

 

[davegb]

One way:

Format your cells as white (no shading). Select the cells to
Conditionally format (with, say, cell A1 the active cell), and set the
dropdowns and inputbox to read

CF1: Formula is =LEN(A1)>0
Format1: <patterns>/<selected color>




- Show quoted text -

Thanks for your reply. Worked great!

I also want to put in some underlining in some cells based on whether
an adjacent cell is blank or non-blank. Do you know how to do that?

 

[JE McGimpsey]

One way:

Add the underlining to the CF format.

 

[davegb]

One way:

Add the underlining to the CF format.



- Show quoted text -

Thanks for the reply. That was what I was planning to do, but I don't
know how to test a nearby cell (probably will use the offset property)
to see if it has a date or a number in it to determine the formatting
of the cell in question. Any ideas?

 

[JE McGimpsey]

Any ideas?

Lots, but there's no way of knowing which would be most appropriate
without something more specific than "test a nearby cell", and "see if
it has a date or a number in it".

 

[davegb]

Lots, but there's no way of knowing which would be most appropriate
without something more specific than "test a nearby cell", and "see if
it has a date or a number in it".



- Show quoted text -

Thanks for your help. I think I'll just format the spreadsheet
manually, I can't devote a great deal of time to this right now.