Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional formating for text 2

Status
Not open for further replies.
jcwoods

jcwoods

IS-IT--Management
Sep 7, 2001
4
0
0
US

The conditional format feature in Excel is easy to use with numbers. Can anyone tell me how to use conditional formating with text? Can conditional formating be included with an IF formula?
Thanks for your help.
 
Sort by date Sort by votes
It is quite the same. Just use "" in the condition field. Like ="The Text that will be affected"

cheers!
Marcos.
 
Upvote 0 Downvote
Hi JC,

If you'd like to email me, I'll be pleased to send you the file I've been offering under the heading "Excel Cute Quiz - Examples of Conditional Formatting, etc".

You'll enjoy the file, plus it will provide examples of what you're looking for.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

scubafrog79
  • Locked
  • Question
Formula for checking cells for value and then subtract value 1
Replies
8
Views
123
SkipVought
S
jlr123
  • Locked
  • Question
Highlight (any) first text word that is a duplicate
Replies
2
Views
122
SkipVought
S
remeng
  • Locked
  • Question
Power BI - Conditional Formatting on value issue
Replies
0
Views
52
remeng
remeng
philrock
  • Locked
  • Question
Looking for text/equation searchable word processor
Replies
11
Views
125
macropod
macropod
dgillz
  • Locked
  • Question
Outlook 365 - flagging messages for follow-up
Replies
0
Views
50
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top