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!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Conditional Format - text 1
- Thread starter Gavona
- Start date
-
1
- #2
DaleWatson123321
Programmer
Gavona,
This will work...
In Conditional Formatting window, use:
Formula is: =ISTEXT(A1)
and of course choose "Format" and then a "Pattern" of your choice.
Hope this helps.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
This will work...
In Conditional Formatting window, use:
Formula is: =ISTEXT(A1)
and of course choose "Format" and then a "Pattern" of your choice.
Hope this helps.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
DaleWatson123321
Programmer
P.S.
Perhaps I should have mentioned... to enter the formatting in the current cell (I used A1), and then copy it to whatever range you require the formatting.
Please advise as to how you make out.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
Perhaps I should have mentioned... to enter the formatting in the current cell (I used A1), and then copy it to whatever range you require the formatting.
Please advise as to how you make out.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question