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