Column Formula to Highlight Rows from the Current Week

HenryWong

I am trying to create a conditional format to highlight rows from the current week (starting Monday), based off the Start Date column.

I have found a formula here but it wont let me convert to a Column Formula:

=IF(WEEKNUMBER([Start Date]1) = WEEKNUMBER(TODAY()), 1)

I added the conditional formatting but it is not working.

Additionally, sometimes we have a row without a date yet. Is there a way to add to the formula to ignore empty cells so that it doesnt give off the INVALID code?

Mike TV

@HenryWong

You can't make it a column formula because you're specifying an exact cell instead of @row, etc. Your formula should be (and then you can make it a column formula):

=IF(WEEKNUMBER([Start Date]@row) = WEEKNUMBER(TODAY()), 1)

Please show your conditional formatting setup.

For the error when blank problem:

=IFERROR(IF(WEEKNUMBER([Start Date]@row) = WEEKNUMBER(TODAY()), 1), "")

HenryWong

Thank you! That formula worked! Conditional formatting still doesn't work..however.

HenryWong

Duplicate

Mike TV

@HenryWong

On the "this format", change the fill background color to yellow using this icon:

You've set the task bar color to yellow but that only shows on card view or calendar view or something like that, I forget.

HenryWong

@Mike TV Thank you so much, Michael!