Hello,
Is there any way to change a cell's color once a week on a certain day on a regular basis. Example, only on Wednesdays cell color changes to pink automatically. Then reverts back to its original color on every other day untill Wednesday comes around again, and so on. . .
Configuration: Windows XP Firefox 3.0.1
Try this. I could not test as I have to wait for seven days to completely test. Today 14th October it works.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$1" Then Exit Sub
If Weekday(Range("A1")) Mod 7 = 4 Then
Range("B1").Interior.ColorIndex = 3
Else
Range("B1").Interior.ColorIndex = xlNone
End If
End Sub
everyday automatically the entry in A1 will change to that day now when the week day of A1 becomes Wednesday the color in B1 will change to red. check for a few days and confirm whether it is ok
|
"vba cell color" Calc change cell color function Change cell color in ms excel example Change cell color when numbers, date or text are entered,(with example) Change google color Change language windows 7 Change the color cartridge canon mx700 Changing the color cartridge canon mx700 Dos command for files created in last 7 days Dos delete files older than 7 days Dos script for files created in last 7 days Excel 2003 - change the color of a cell based on another cell's color Excel change cell color if cell contains text Excel formula to change cell color How to change wallpaper windows 7 basic Html change background color multiple times Vb 6 application interface not changing in windows 7 Visual basic conditional formatting cell color change