Related:
- Selection.interior.colorindex
- Notepad++ change background color - Guide
- Skype last seen days ago - Guide
- Excel cell color formula - Guide
- Microsoft store download windows 7 - Download - App downloads
- Color 65535 - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 14, 2009 at 06:00 AM
Oct 14, 2009 at 06:00 AM
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
Oct 14, 2009 at 06:26 AM
Oct 19, 2009 at 09:13 AM
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
Dec 22, 2011 at 01:14 PM
Dec 22, 2011 at 01:15 PM
Dec 22, 2011 at 01:17 PM