# Excel - IF Function Problem - Expert Solution

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

Hello, I am trying to format a cell based on the value of another cell. So for my spreadsheet I need cell I6 to be purple if the percentage shown in cell J6 is less than 23.5%. Would you be able to help? Many thanks
Solved by C. W. in 17 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 21/08/2018 - 01:10
Hi there!
User 21/08/2018 - 01:10
Hello
Excelchat Expert 21/08/2018 - 01:10
User 21/08/2018 - 01:10
Excel
Excelchat Expert 21/08/2018 - 01:11
Ok fantastic - have you ever used formula based conditional formatting before?
User 21/08/2018 - 01:11
Nope
Excelchat Expert 21/08/2018 - 01:11
No problem I will walk you through it!
Excelchat Expert 21/08/2018 - 01:11
So click on cell I6
Excelchat Expert 21/08/2018 - 01:12
Then from the main "Home" menu, there is a button called Conditional Formatting
Excelchat Expert 21/08/2018 - 01:12
In your own file I mean :)
User 21/08/2018 - 01:13
Yes
Excelchat Expert 21/08/2018 - 01:13
from the conditional formatting menu, you would select "New Rule"
User 21/08/2018 - 01:13
yes
Excelchat Expert 21/08/2018 - 01:13
Then, select the bottom option "use a formula to determine which cells to format"
User 21/08/2018 - 01:14
yes
Excelchat Expert 21/08/2018 - 01:14
This is the formula you'd enter
Excelchat Expert 21/08/2018 - 01:14
and then, select the color that you want to apply
Excelchat Expert 21/08/2018 - 01:14
(purple)
Excelchat Expert 21/08/2018 - 01:15
Then press, OK, then Apply, Then OK
Excelchat Expert 21/08/2018 - 01:15
Let me know if it works on your end!
User 21/08/2018 - 01:15
Have you sent the formula?
Excelchat Expert 21/08/2018 - 01:16
Oh no!
Excelchat Expert 21/08/2018 - 01:16
=\$J\$6<0.235
Excelchat Expert 21/08/2018 - 01:16
I forgot to paste it in, there you go - sorry!
User 21/08/2018 - 01:18
Nice one! Thank's for the help!
Excelchat Expert 21/08/2018 - 01:19
Awesome! My pleasure and please don't hesitate to reach back out to us with a new session if you need more help and we will be happy to assist.
Excelchat Expert 21/08/2018 - 01:19
All the best ~

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.