Dear Abhishek
Thanks sir
Problem Solved
Regards
Shrinivas
On Thu, Dec 31, 2015 at 3:39 PM, Abhishek Jain
wrote:
> The formula is to be used in conditional formatting dialog box only...not
> in B1.
>
> PFA sample attached.
>
> On Thu, Dec 31, 2015 at 3:00 PM, Shrinivas Shevde
> wrote:
>
>> Dear
The formula is to be used in conditional formatting dialog box only...not
in B1.
PFA sample attached.
On Thu, Dec 31, 2015 at 3:00 PM, Shrinivas Shevde
wrote:
> Dear Abhishek
> Thanks for reply.
> Actually already some value in cell b1.
> In short I have a date of material received in cell a1 a
Dear Abhishek
Thanks for reply.
Actually already some value in cell b1.
In short I have a date of material received in cell a1 and qty in cell b1.
But shelf life of material is only 15 days so i want to highlight that once
the 15 days over
I cant put formula in B1 so I want conditional formating
You can use below formula in B1 and set desired format. Then copy B1 and
select rest of the cells where you want the formatting and use Paste
Special > Formats.
*=AND(A1<>"",A1<=TODAY()-15)*
On Thu, Dec 31, 2015 at 11:50 AM, Shrinivas Shevde
wrote:
> Dear all
> One small query.
> I have a dat
Dear all
One small query.
I have a date in Cell a1 I want to format a cell b1, such that whenver
the 15 days over the cell b1 should fill with any colour.
Eg A1 has 10th jan 2015 then cell b1 should fill with any colour on 26th
jan 2015
Is it possible if yes please let me know how to do the same.
