Apply Colour to cell & blink

  • Thread starter Thread starter shital
  • Start date Start date
S

shital

I have data filed like: -
Bill no., Bill Date, Party Name, Item, Qty
I want to have data on party name with outstanding of over
30 days from system date & also want to use a different
Colour to cell attention to outstanding of over 60 days.

And can I Blink that cell which has fulfill the condition.
pls. help me.

shital
 
Take a look at Conditional Formatting in XL Help.

Your conditions will be with, say, your Bill date in column B and
the Quantity column, row 2 selected:

CF1: =(TODAY()-$B2)>60
Format1: ==> Color 1

CF2: =(TODAY()-$B2)>30
Format2: ==> Color 2

I'd strongly advise you not have your cell Blink - it gets really
irritating really fast. But if you insist, you can search the
archives for VBA code that will do it:

http://google.com/advanced_group_search?q=group:*excel*

Use "blink" as a search term.
 
Thanks it's working
thank you vary much....
-----Original Message-----
Take a look at Conditional Formatting in XL Help.

Your conditions will be with, say, your Bill date in column B and
the Quantity column, row 2 selected:

CF1: =(TODAY()-$B2)>60
Format1: ==> Color 1

CF2: =(TODAY()-$B2)>30
Format2: ==> Color 2

I'd strongly advise you not have your cell Blink - it gets really
irritating really fast. But if you insist, you can search the
archives for VBA code that will do it:

http://google.com/advanced_group_search? q=group:*excel*

Use "blink" as a search term.


.
Click to expand...
 
Back
Top