Tags: CONDITIONAL FORMATTING

Analyse all possible combinations of cheques received and identify the combination which gives maximum benefit to the Customer

{ 11 Comments }

Scenario 1 In a Stock Broking business (Firm), Customers deposit margin money through cheques. Although cheques are received from customers at branches, clearing (realization) of the same normally takes 3-4 days.  On one hand, the Firm wishes to allow trading to the customers against the deposited cheques from the day it receives the cheque, on other hand there is […]

Read More →

Applying conditional formatting to column charts

{ 8 Comments }

Line of Business (LoB) wise CAGR (%) is shown in range A3:B8.  A benchmark growth rate is shown in cell B11.  The task to show a column chart of the data presented in range A3:B8.  LoB’s with a CAGR (%) greater than the benchmark rate should appear in Green colour and those with a CAGR (%) […]

Read More →