Home |
Search |
Today's Posts |
#1
|
|||
|
|||
color cells with text
How do I use conditional formatting to color any cell with text in it?
Thank you! |
#2
|
|||
|
|||
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" wrote in message ... How do I use conditional formatting to color any cell with text in it? Thank you! |
#3
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |