color cells with text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to automatically go to the right of the last colored cell 0
Excel VBA 1
How to extract separated text by many commas in Excel? 0
Conditional Formatting 4th Condition 3
Conditional format cell containing hyperlink 2
Does anyone have any suggesitons on how to do it for worksheet? 1
conditional format of entire row based on a single cell in row 7
Changing Color of the Cell under Certain Conditions 8

Back
Top