Random color for letter

sksanjeev786

Well-known Member
Joined
Aug 5, 2020
Messages
873
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi Team,

I have an excel sheet in which I have random alphabetic letter like in each cell i.e A,c,D,F


483642334235
zALMjC


so can I get any idea on this I need any color for letter

Thanks.
Regards,
Sanjeev
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Hi Team,

I have an excel sheet in which I have random alphabetic letter like in each cell i.e A,c,D,F


483642334235
zALMjC


so can I get any idea on this I need any color for letter

Thanks.
Regards,
Sanjeev



Hi Team,
Any help on this

I need any color on cell if we get letter on any cell from A to Z or a to z . Example given in D column

Added data via XLB

MR Excel_1016.xlsx
ABCD
2Top 2 box57 A57 A
3Very much3535
4Not much13 j13 j
5Not at all11 M11 M
6Not at all11 B11 B
Sheet3


Thanks
Sanjeev
 
Upvote 0
Try Conditional Formatting
formula
Code:
=ISTEXT(B1)
 
Upvote 0
Hi Team,

I have an excel sheet in which I have random alphabetic letter like in each cell i.e A,c,D,F


483642334235
zALMjC


so can I get any idea on this I need any color for letter

Thanks.
Regards,
Sanjeev



Hi Team,
Any help on this

I need any color on cell if we get letter on any cell from A to Z or a to z . Example given in D column

Added data via XLB

MR Excel_1016.xlsx
ABCD
2Top 2 box57 A57 A
3Very much3535
4Not much13 j13 j
5Not at all11 M11 M
6Not at all11 B11 B
Sheet3


Thanks
Sanjeev\\
Try Conditional Formatting
formula
Code:
=ISTEXT(B1)


Hi I have tried but color is not coming could you please check and let me know


Thanks in advance
Regards,
Sanjeev
 
Upvote 0
Does column B contain formulas or just manually entered values?
If formulas, what is the formula in B2?
 
Upvote 0
Does column B contain formulas or just manually entered values?
If formulas, what is the formula in B2?


Hi Peter,

Thanks for checking on this B column doestn contain any formula it has random letter only so i need color where ever we have letter like 33 B or any letter from A to Z

Thanks.
Regards,
Sanjeev
 
Upvote 0
From what I can see then navic has given you the basic solution. Perhaps it hasn't been implemented quite correctly.
For the layout below, follow these steps.

  1. Select from B2 to B6
  2. Home ribbon tab -> Conditional Formatting -> New rule ... -> Use a formula to determine which cells to format -> Format values where this formula is true:- =ISTEXT(B2) -> Format... -> Fill tab -> Choose your colour -> OK -> OK

20 12 21.xlsm
AB
1
2Top 2 box57 A
3Very much35
4Not much13 j
5Not at all11 M
6Not at all11 B
CF with letters
Cells with Conditional Formatting
CellConditionCell FormatStop If True
B2:B6Expression=ISTEXT(B2)textNO
 
Upvote 0
From what I can see then navic has given you the basic solution. Perhaps it hasn't been implemented quite correctly.
For the layout below, follow these steps.

  1. Select from B2 to B6
  2. Home ribbon tab -> Conditional Formatting -> New rule ... -> Use a formula to determine which cells to format -> Format values where this formula is true:- =ISTEXT(B2) -> Format... -> Fill tab -> Choose your colour -> OK -> OK

20 12 21.xlsm
AB
1
2Top 2 box57 A
3Very much35
4Not much13 j
5Not at all11 M
6Not at all11 B
CF with letters
Cells with Conditional Formatting
CellConditionCell FormatStop If True
B2:B6Expression=ISTEXT(B2)textNO

Perfect Peter :):)

Thanks for your help on this.
 
Upvote 0
You're welcome, but navic really provided the solution, I just clarified how to implement it. :)
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,952
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top