# Excel - IF Function Problem - Expert Solution

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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.