yogi_Conditionally Format Cells A2:I8 Based On DayOfWeek Today

Google Spreadsheet   Post  #2569

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-06-2019

question by: Lauren Edmondson:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/7I8JCC_1iS4;context-place=forum/docs
Formula for Highlighting Row Based off Value in Cell (Day of the week)
Hello,

I have a spreadsheet set up so that the row for the current day of the week is highlighted on that day. So example, if its Sunday, the whole Sunday row is lit up. It worked all of last year but now I can't get it to work, its displaying that its the wrong day (Monday instead of Sunday). I've tried changing a few things but can't get it to work right. Does anyone know a formula to get this working correctly? Here's the one I'm using now:

=weekday(today())=row(A1)

Applied to the range of the cells that have the day of the week in them. 

Thank you!