# Excel - IF Function Problem - Expert Solution

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

i want to create the format of stock of material for eg: in excel we have 10000 pcs of paper stock and we have ordered 25000 pcs of paper in that 5000 pcs have dispatched balance has to dispatch min should be 20000 pcs if that cross the min it should highlet in bold and with big size
Solved by G. H. in 24 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 14/04/2018 - 06:40
Hi
Excelchat Expert 14/04/2018 - 06:40
Welcome to Got it Pro
User 14/04/2018 - 06:41
hi
Excelchat Expert 14/04/2018 - 06:41
Can you elaborate more on your requirement?
User 14/04/2018 - 06:48
when the balance is -1500 it should show in bold and big in font size
Excelchat Expert 14/04/2018 - 06:49
what is the formula used in D
Excelchat Expert 14/04/2018 - 06:50
is it stock - min stock?
Excelchat Expert 14/04/2018 - 06:50
then why it is negative
User 14/04/2018 - 06:50
no
User 14/04/2018 - 06:51
min should be 1500 if its less then it should high light
Excelchat Expert 14/04/2018 - 06:52
ok
Excelchat Expert 14/04/2018 - 06:53
i think for this you will need to use VBA
Excelchat Expert 14/04/2018 - 06:53
https://www.extendoffice.com/documents/excel/3316-excel-bold-if-greater-than.html
Excelchat Expert 14/04/2018 - 06:54
Please have a look at the vba code
Excelchat Expert 14/04/2018 - 06:54
this is how you will have to do
User 14/04/2018 - 06:54
how
Excelchat Expert 14/04/2018 - 06:55
Unfortunately this platform is not for VBA
Excelchat Expert 14/04/2018 - 06:55
this is for worksheet related queries
Excelchat Expert 14/04/2018 - 06:56
My expertise is limited to excel and formulas
Excelchat Expert 14/04/2018 - 06:56
For vba you jsut need to use this code make slight modifcations and run
User 14/04/2018 - 06:57
show me how to do
Excelchat Expert 14/04/2018 - 06:57
You can do it using conditional formatting
Excelchat Expert 14/04/2018 - 06:57
Let me show you
User 14/04/2018 - 06:58
pls
Excelchat Expert 14/04/2018 - 06:58
See this file
[Uploaded an Excel file]
User 14/04/2018 - 06:58
ur not charging for this conversation
Excelchat Expert 14/04/2018 - 06:59
Do you know how to use conditional formatting?
User 14/04/2018 - 06:59
right
Excelchat Expert 14/04/2018 - 06:59
so when you click on the cell and then click on conditional formatting
Excelchat Expert 14/04/2018 - 06:59
then select new rule
Excelchat Expert 14/04/2018 - 06:59
in the rule use when cell value is less than 0 then choose fold and font as per your requirement
Excelchat Expert 14/04/2018 - 07:00
Hope this helps
User 14/04/2018 - 07:00
k tq i ll try
Excelchat Expert 14/04/2018 - 07:00
Yes please
Excelchat Expert 14/04/2018 - 07:00
Please do give good rating
Excelchat Expert 14/04/2018 - 07:00
It really helps
User 14/04/2018 - 07:01
k
Excelchat Expert 14/04/2018 - 07:01
Let me know if you need anything else
Excelchat Expert 14/04/2018 - 07:02
You can end the session when done
Excelchat Expert 14/04/2018 - 07:04
Are you there?
Excelchat Expert 14/04/2018 - 07:04
Do you need anything else?
User 14/04/2018 - 07:05
no
Excelchat Expert 14/04/2018 - 07:05
ok
Excelchat Expert 14/04/2018 - 07:05
You can end the session then

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.

## Click here to get your free Excelchat help session

Trusted by people who work at