Related:
- Change cell color every 7 days
- How to change taskbar color windows 7 - How-To - Windows 7
- Excel vba change cell color based on value ✓ - Forum - Programming
- Can't change taskbar color windows 7 ✓ - Forum - Windows
- Excel vba change cell color - How-To - Excel
- Change cell color based on another column ✓ - Forum - Excel
1 reply
venkat1926
- Posts
- 1862
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- July 30, 2015
try this. I could not test as I have to wait for seven days to completely test. Today 14th October it works.
first type in A1
=today()
right click the tab of the sheet and click view code. and in that window copy this code
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
first type in A1
=today()
right click the tab of the sheet and click view code. and in that window copy this code
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
Subscribe To Our Newsletter!
Use this formula to determine the day (in cell A1 for example):
=weekday(today())
This formula give you a number: Sunday=1, Monday=2 etc.
Now you can use conditional formating.
Use formula is, and input A1=4 (4 for wednesday) and apply your color.
For your next condition use this formula: A1<>4 and apply your color.
Is this the answer you were looking for?
Best regards,
Trowa