Welcome Guest
Log In | Register )
You last visited December 3, 2016, 4:44 pm
All times shown are
Eastern Time (GMT-5:00)

Excel and changing text color

Topic closed. 15 replies. Last post 4 months ago by gladys48.

Page 2 of 2
51
PrintE-mailLink
gladys48's avatar - animaniacs07
Newnan GA
United States
Member #176392
August 3, 2016
171 Posts
Offline
Posted: August 10, 2016, 11:46 am - IP Logged

a)

Choose tab data.
Select your cells on the sheet.
Click on "text to columns".
Follow instructions on the form.

b)

Choose tab home.
Select your cells to format.
Conditional formatting.
New Formatting Rule.
Use a formula to ... .
Enter a formula.
Set the Format to apply.
Click ok to view the result.

Options:

Use the function mid instead of text to columns.

When it isn't a string, use cells.
Programmers can do otherwise.

4423 9962     VTrav

5523   9923

2343   5562   

3534