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