# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I am trying to write a formula that if cell AK141 has a value in it that cell S141 is highlighted a color
Solved by O. W. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 20/08/2018 - 06:44
Hi there!
Excelchat Expert 20/08/2018 - 06:44
I believe we can use formula based conditional formatting to solve this for you. Are you using Excel or Google Sheets?
User 20/08/2018 - 06:45
Excelchat Expert 20/08/2018 - 06:45
Ok perfect
Excelchat Expert 20/08/2018 - 06:45
Have you ever used conditional formatting before?
User 20/08/2018 - 06:45
no
Excelchat Expert 20/08/2018 - 06:45
No problem I will walk you through this.
Excelchat Expert 20/08/2018 - 06:45
can you see the google sheet over there -->
User 20/08/2018 - 06:45
yes
Excelchat Expert 20/08/2018 - 06:46
Ok excellent
Excelchat Expert 20/08/2018 - 06:46
I will set it up in cell AK141 just like your example
Excelchat Expert 20/08/2018 - 06:47
S141 rather
Excelchat Expert 20/08/2018 - 06:47
So in AK141... what type of value will be entered? a number?
User 20/08/2018 - 06:47
a dollar amount
Excelchat Expert 20/08/2018 - 06:48
so if there is ANY amount or value in cell AK141, then turn S141 a color?
User 20/08/2018 - 06:48
correct
Excelchat Expert 20/08/2018 - 06:48
ok great
Excelchat Expert 20/08/2018 - 06:48
Go to cell S141
User 20/08/2018 - 06:48
ok
Excelchat Expert 20/08/2018 - 06:48
Format
Excelchat Expert 20/08/2018 - 06:48
Conditional Formatting
User 20/08/2018 - 06:49
ok
Excelchat Expert 20/08/2018 - 06:49
Format cells if:
Excelchat Expert 20/08/2018 - 06:49
custom formula (at the bottom)
User 20/08/2018 - 06:49
ok
Excelchat Expert 20/08/2018 - 06:50
Sorry let me try something else
User 20/08/2018 - 06:50
ok
Excelchat Expert 20/08/2018 - 06:51
=Len(AK141)>0
Excelchat Expert 20/08/2018 - 06:51
thats the custom formula
Excelchat Expert 20/08/2018 - 06:52
So if you type any value in AK141, then S141 will turn whatever color you select.
User 20/08/2018 - 06:52
thank you so much!!!
Excelchat Expert 20/08/2018 - 06:52
Let me know if it works on your end on your sheet!
Excelchat Expert 20/08/2018 - 06:52
It worked?
User 20/08/2018 - 06:53
yep
Excelchat Expert 20/08/2018 - 06:53
Yay!
Excelchat Expert 20/08/2018 - 06:53
My pleasure and please feel free to reach back out with a new session if you need more help and we will be happy to assist.
Excelchat Expert 20/08/2018 - 06:53
All the very best ~
User 20/08/2018 - 07:02
I have another question
User 20/08/2018 - 07:02
how do i copy that formula to the next row and have it change the row number
Excelchat Expert 20/08/2018 - 07:03
You can just drag the cell down just like you drag a formula down
User 20/08/2018 - 07:03
but it still says 141
Excelchat Expert 20/08/2018 - 07:03
And the formatting will dynamically update to the row
User 20/08/2018 - 07:03
it doesn't change it to 142...etc
Excelchat Expert 20/08/2018 - 07:03
Yep thats ok
Excelchat Expert 20/08/2018 - 07:04

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.