Hello
I would like to fill color the row with conditional formatting using formula.
If the birthdate is Sunday the row contain sunday must be red.
If the birthdate is Monday the row contain Monday must be Yellow.
If the birthdate is Tuesday the row contain Tuesday must be pink.
If the birthdate is Wednesday the row contain Wednesday must be Green.
If the birthdate is Thurday the row contain Thursday must be Orange.
If the birthdate is Friday the row contain Friday must be Cyan.
If the birthdate is Saturday the row contain Thursday must be Purple.
I using Weekday function to get the dayweek order in conditional formatting. Unluckily the maximum conditional formatting in Excel 2003 are 3 conditionals.
I heard that the Excel Macro 4.0 had function to get the cell colour. But I don't have experience using Excel Macro 4.0 before!
Is the any solution that using Excel Macro 4 function with Condtional Formatting
I have attached the file for study.
Thanks for your help.
Sincerely your.
Bookmarks