Question description:
This user has given permission to use the problem statement for this
blog.
I have letters in cell A1 which I would like highlighting in a fill colour if any numerical values are entered in cells B1 to T1. Can this be done please?
Solved by B. W. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
12/04/2018 - 12:21
Welcome to Got It Pro
User
12/04/2018 - 12:22
ty
Excelchat Expert
12/04/2018 - 12:22
Let me show you how in preview window
User
12/04/2018 - 12:23
:)
Excelchat Expert
12/04/2018 - 12:23
One question?
Excelchat Expert
12/04/2018 - 12:23
Is cell A1 is empty or it contains some values?
User
12/04/2018 - 12:24
it has letters in it
Excelchat Expert
12/04/2018 - 12:24
Like I entered in cell A1
Excelchat Expert
12/04/2018 - 12:25
Right?
User
12/04/2018 - 12:25
yes
Excelchat Expert
12/04/2018 - 12:26
You need to use formula to conditionally highlight cell A1 as follows
Excelchat Expert
12/04/2018 - 12:27
=ISNUMBER(B$1)
Excelchat Expert
12/04/2018 - 12:31
Let me put some other conditions too
Excelchat Expert
12/04/2018 - 12:33
Please wait
Excelchat Expert
12/04/2018 - 12:36
I have fixed that now
Excelchat Expert
12/04/2018 - 12:37
It will used as follows
Excelchat Expert
12/04/2018 - 12:37
=OR(ISNUMBER($B$1),ISNUMBER($C$1),ISNUMBER($D$1),ISNUMBER($E$1),ISNUMBER($F$1),ISNUMBER($G$1),ISNUMBER($H$1),ISNUMBER($I$1),ISNUMBER($J$1),ISNUMBER($K$1),ISNUMBER($L$1),ISNUMBER($M$1),ISNUMBER($N$1),ISNUMBER($O$1),ISNUMBER($P$1),ISNUMBER($Q$1),ISNUMBER($R$1),ISNUMBER($S$1),ISNUMBER($T$1))
Excelchat Expert
12/04/2018 - 12:37
In conditional formatting
Excelchat Expert
12/04/2018 - 12:38
When you will enter any numaric value in any cell ranging from B1 to T1
Excelchat Expert
12/04/2018 - 12:38
cell A1 will be highlighted automatically
Excelchat Expert
12/04/2018 - 12:41
Are you proficient in using conditional formatting in Excel, Or I should guide you how to enter this formula in conditional formatting?
User
12/04/2018 - 12:41
I think I will be okay now, many thanks for your help
User
12/04/2018 - 12:41
much appreciated
Excelchat Expert
12/04/2018 - 12:41
Please rate 5 star if you liked the solution
Excelchat Expert
12/04/2018 - 12:42
When you will close this session, rating window popups.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
