NiteCrawlr
Programmer
How can I make a VBA code in Excel that identify weekends in a Date type cell. When it identify a weekend I want it to change the color of the whole line.
Help please,
TKS
Nite
Help please,
TKS
Nite
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Function CellColor(Source As Range) As Integer
Application.Volatile
CellColor = Source.Font.ColorIndex
End Function
=IF(cellcolor(A1)=3;"Font is Red";"Font is not Red")
=IF(cellcolor(A2)=6;"Font is Yellow";"Font is not Yellow")
=IF(cellcolor(A4)=10;"Font is Green";"Font is not Green")
=IF(cellcolor(A5)=1;"Font is Black";"Font is not Black")
=IF(cellcolor(A6)=2;"Font is White";"Font is not White")
=IF(cellcolor(A7)=46;"Font is Orange";"Font is not Orange")