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

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>

In article <(E-Mail Removed)>,
"davegb" <(E-Mail Removed)> wrote:

> 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

On Mar 27, 9:20 am, JE McGimpsey <jemcgimp...@mvps.org> wrote:
> 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>
>
> In article <1175008431.196607.19...@b75g2000hsg.googlegroups.com>,
>
>
>
> "davegb" <dav...@safebrowse.com> wrote:
> > 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- Hide quoted text -
>
> - 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?

One way:

Add the underlining to the CF format.


In article <(E-Mail Removed)>,
"davegb" <(E-Mail Removed)> wrote:

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

On Mar 27, 10:38 am, JE McGimpsey <jemcgimp...@mvps.org> wrote:
> One way:
>
> Add the underlining to the CF format.
>
> In article <1175011135.308605.6...@e65g2000hsc.googlegroups.com>,
>
>
>
> "davegb" <dav...@safebrowse.com> wrote:
> > 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?- Hide quoted text -
>
> - 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?

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

In article <(E-Mail Removed)>,
"davegb" <(E-Mail Removed)> wrote:

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

On Mar 27, 4:34 pm, JE McGimpsey <jemcgimp...@mvps.org> wrote:
> > 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".
>
> In article <1175034435.405119.167...@y80g2000hsf.googlegroups.com>,
>
>
>
> "davegb" <dav...@safebrowse.com> wrote:
> > 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.- Hide quoted text -
>
> - 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.