How do I use conditional formatting to color any cell with text in it?
Thank you!
How do I use conditional formatting to color any cell with text in it?
Thank you!
Hi Eliane
assuming by "text" you mean what Excel means by text (ie not a number or a
boolean) then
select your range
choose format / conditional formatting
choose formula is
type
=ISTEXT(A1)
where A1 is the top left cell of the selected range
click FORMAT - set the formatting you want
click OK twice.
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Eliane" <[email protected]> wrote in message
news:[email protected]...
> How do I use conditional formatting to color any cell with text in it?
>
> Thank you!
Highlight the entire column like Column A.
Format | Conditional Formatting change to Formula is
enter =istext(A1) change the format pattern color and hit ok.
"Eliane" wrote:
> How do I use conditional formatting to color any cell with text in it?
>
> Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks