changing cell color every cpecific date..

December 24, 2011 at 03:50:44
Specs: Windows 7
ok, look i have a customer that stored somthing in the warehouse in 10/11/2011 and the fee is- for exmaple- 200$ per month ,so i used cell A1 for the name cell B1 for the date he started and cell C1 for the cost,what i need is to make cell D1 to flash red every 10th of any month, and when i write paid on cell E1 it stop flashing untill the next month ,

i hope that i provided u with enough details

See More: changing cell color every cpecific date..

Report •

December 24, 2011 at 13:34:12
Read the Excel Help File (or Google) for Conditional Formatting.

You can use the TODAY() function in a Rule and compared it to the 10th of each month to format the cell. However, in order to make the cell flash, I believe that you are going to need VBA. See here:

I also don't understand how you plan to use Paid in E1. Once you enter Paid in E1 to stop the flashing, are you planning on deleting it so that you can enter it again next month? That doesn't sound like a good way to accomplish your goal.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question