Conditional Formatting and color coding a cell by the day in the week

Hello all,

I have been searching the forum's and haven't quite found what I am looking for. I am working on an excel spreadsheet and what I am trying to accomplish is based on the current day I want to change the color of a cell, the thing that sets it apart from what most people have asked in the cell I want to change the color in is only text. As in the cell will say Attendance Report Completed. What would be the right conditional code to basically say if the current day is Saturday then make this cell Red for today only and tomorrow when I open the file it will be back to normal color. Is that kind of formula possible? Thanks for any help in advance. Using Excel 2016 Pro Plus.

With your long day of the week in A1, use this conditional format rule;

Formula:

Please Login or Register  to view this content.

Those worked great! Thank you I appreciate it!