Assume the following numbers in range C5:C22. Heading is in cell C4. Range C5:C7 – 11 Range C8:C11 – 14 Range C12:C13 – 23 Range C14-C19 – 56 Range C20-C22 – 78 One may want to colour cells for every change in number in range C5:C22 with the following two modifications: 1. Shading should be for […]
Read More →
Conditionally formatting duplicate values across all versions of MS Excel is quite simple. However, to colour different duplicate values in different colours, refer to this workbook.
Read More →
{ 0 Comments }
If a certain cell entry is found in column C of the other eleven sheets, then colour the entry in red. Furthermore, a summary sheet should show all red coloured entries. You may refer to my solution in this workbook.
Read More →
{ 13 Comments }
To display numbers in Indian currency format, use the following custom number format [>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00
Read More →
Shade alternate band of rows in a filtered range
{ 4 Comments }