ow if
> this is the desired solution. I have added data validation in column E.
>
> Best regards,
> Ayush Jain
> [Group Manager & Owner]
>
>
> --- On *Sun, 15/11/09, Abhishek Jain * wrote:
>
>
> From: Abhishek Jain
> Subject: $$Excel-Macros$$ Re: Custom Num
rote:
From: Abhishek Jain
Subject: $$Excel-Macros$$ Re: Custom Number Format - Help >>>URGENT<<<
To: "Ayush"
Cc: "MS EXCEL AND VBA MACROS"
Date: Sunday, 15 November, 2009, 1:21 PM
Hello Ayush,
Thank you very much for the macro which worked exactly as expected
Hello Ayush,
Thank you very much for the macro which worked exactly as expected. The only
problem was that I already had entries filled up, for which I used your
macro as a separate module and it solved the issue.
Although not related to this question - I am going to send this file to my
managers
Hi Abhishek,
Unfortunately, The custom number format can take only up to two
conditions and you have three conditions in your requirement. Also,
Conditional formatting may not work as it displays colors,borders and
patterns.
I have written a macro for you which should fulfill your requirement.
Th