Posts by KSKwin

Hi Glenn, Thank you.

I will check it, once.

Hi,

I have an excel with Column as Date, Day and other Text columns. Based on date (say current date) the range of columns should be highlighted in color.

Thanks

KSK

Hi,

I want this to be achieved on focus out event or on change event

MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

Hi,

How to change the Excel comments box Font to Caliber, while keying in the comments area (or) focusing out of the comment box with a VBA code.

Below is the code I am using, but I have to run it every time for the font change to update.

Sub FixComments()

Dim cmt As Comment

For Each cmt In ActiveSheet.Comments

With cmt.Shape.TextFrame.Characters.Font

.Name = "Calibri"

.Size = 8

End With

Next cmt

End Sub

Hi, How to combine the below formulae {both positive & negative cases)

[<=-10000000]""- ##\,##\,##\,##0;[<=-100000]"" - ##\,##\,##0;" "##,##0

[>=10000000]" "##\,##\,##\,##0;[>=100000]" " ##\,##\,##0;" "##,##0

Hi,

I tried this formula [<=-100000000]" "- ##\,##\,##\,##\,##0;[<=-100000]" "- ##\,##\,##0;0.

Seems ok.

Pl. let me know if any issue you forecast .

Thanks for your help.

Hi Carim & Ingo - Thanks for your reply.

Carim

Applied your formula. [>=10000000]" "##,##,##,##0;[<0]" "\ ##,##,##0;" "##'##0

But only minus (-) is removed with the no number separator

COL A COL B COL C COL D COL E

Item A B C D

Qty 1,200 1,000 800 3,000

Price 2,200 2,000 1,200 4,000

Amount 26,40,000 20,00,000 9,60,000 1,20,00,000

Expected :- if the result is a negative number -xxxxxxxxxx. It should to displayed as -x,xx,xx,xx,xxx

Amount is the Product of Qty and Price.

=B4-C4 => 20,00,000 - 9,60,000 = 6,40,000. [resulted a postive number and number format seperated is ok (x,xx,xxx)

=C4-B4 => 20,00,000 - 26,40,000 = 640,000. (got result applying >=10000000]" "##,##,##,##0;[<0]" "\ ##,##,##0;" "##'##0

It should be displayed as -6,40,000.

What is needed :

For Negative result -> negative symbol with result & Number separator X,XX,XX,XX,XXX

ingo

When applying your formula, negative symbol is not showing, but the separator are ok.

=C4-B4 => 20,00,000 - 26,40,000 = 6,40,000

Needed -> negative symbol with result & Number separator X,XX,XX,XX,XXX

.

I have an excel to calculate the product price and difference in amount

I am using the number format as [>=10000000]" "##\,##\,##\,##0;[>=100000]" " ##\,##\,##0;" "##,##0

1) if the difference in amount is positive, the result value is satisfying the above number format

2) if the difference is negative, its not showing as above number format.

Pl. help in showing the result as expected.

Attachment: Attached is the Excel.

Thanks

KSK

Hi Carim,

Fantastic. Awesome Job.

Hi Carim,

Thanks for your good job getting this useful. There are a few tweaks needed here.

Each cell be populate with values once entered with number in a individual cell.

for eg., A1 is entered with 2 , it should show 1000

and A2 entered with 1, it should show 200.

A3 with 1, should show 100

A4 with 1, should show 50

till A6.

3. Now B1 entered with 4, should show 1000

B2 entered with 2, should show 400

till B6.

4. For C1 to C6

till Z1 to Z6. once the individual cell is entered with number.

Pl refer sheet2 of the attachment.

Denomination Pieces Amount500 2 1000
200 2 400
100 1 100
50 1 50
20 1 20
10 1 10
---------------------------------------
1580

What I need is to precalculate with the various denomination figures, when I enter numbers (for the pieces) in Amount column. Finally, i will have only one column [Amount], with precalculated value.