Question description:
This user has given permission to use the problem statement for this
blog.
i have a column that is providing a function, how can i get certain cells to be highlighted if they fell below a certain value?
Solved by F. B. in 13 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
10/09/2018 - 09:41
Welcome, Thanks for choosing Got It Pro-Excel.
Excelchat Expert
10/09/2018 - 09:42
Do you have sample data?
User
10/09/2018 - 09:43
i would like to know how to make the values under 30 in column a different color
Excelchat Expert
10/09/2018 - 09:43
Okay.
Excelchat Expert
10/09/2018 - 09:43
Kindly following this procedure with me.
Excelchat Expert
10/09/2018 - 09:44
STEP 1
Excelchat Expert
10/09/2018 - 09:45
Select the range which contains all the data for which you want to highlight.
Excelchat Expert
10/09/2018 - 09:46
Are you following?
User
10/09/2018 - 09:46
yes
Excelchat Expert
10/09/2018 - 09:47
The steps for conditional formatting for google sheets are different from your Excel desktop application.
Excelchat Expert
10/09/2018 - 09:47
Which one are you using?
Excelchat Expert
10/09/2018 - 09:47
Desktop software or google sheets?
User
10/09/2018 - 09:47
microsoft excel
Excelchat Expert
10/09/2018 - 09:48
Okay.
Excelchat Expert
10/09/2018 - 09:48
Select the range.
Excelchat Expert
10/09/2018 - 09:48
After you have selected, go to:
Excelchat Expert
10/09/2018 - 09:48
On the Home tab, click Conditional Formatting > Highlight Cells Rules >
Excelchat Expert
10/09/2018 - 09:49
Then select less than.
User
10/09/2018 - 09:49
ok
Excelchat Expert
10/09/2018 - 09:49
In the less than dialog box.
Excelchat Expert
10/09/2018 - 09:50
Under the "Format cells that are LESS THAN:" field, enter the value.
Excelchat Expert
10/09/2018 - 09:50
In your case you enter 30.
Excelchat Expert
10/09/2018 - 09:51
In the "with" field, select the formatting that you wish.
User
10/09/2018 - 09:51
it worked, now if i insert lines or delete lines the highlights will stay with the values
Excelchat Expert
10/09/2018 - 09:51
Then click Okay.
Excelchat Expert
10/09/2018 - 09:52
As long as the rows inserted are within the range you had initially selected, the same rules of formatting will be upheld.
User
10/09/2018 - 09:53
awesome, i had done this a long time ago, but could not figure out how to do it again. thanks so much.
Excelchat Expert
10/09/2018 - 09:53
Is there any questions or clarifications you may need in regards to this?
User
10/09/2018 - 09:53
nope i think i can handle it from here.
User
10/09/2018 - 09:53
thank you
Excelchat Expert
10/09/2018 - 09:54
It was my pleasure helping you solve this problem. Any time you have a problem with Excel do not hesitate to come back for help.
Excelchat Expert
10/09/2018 - 09:54
Please remember to rate us at the end of the chat for better and quality services. Thank you!
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.