Formula to turn the background red

Sid

Hi,

I have been struggling with this one. I want background in the column "B", column "C" and Column "D" to turn Red Automatically if the date in the column "A" was more than a week ago.

Any help will be appreciated :)

Neil Watson

Hi

Can you use a "helper column" with a formula such as the below:

And then use conditional formatting.

Neil Watson

@Sid another helper column, with a formula that triggers 24 hrs after the first one? And another set of conditional formats?

Neil Watson

Hi

Can you use a "helper column" with a formula such as the below:

And then use conditional formatting.

Sid

Hello,

Thanks for your reply Neil. I am glad I was thinking along the same lines. Same idea struck to me after posting this questions. I have used check box as a helping column and I have hidden it. I have used the formula below and it kind of worked. however, I don't understand why I had to use 1, 0 at the end.

=IF(AND(ISDATE([Date Job Processed (within 24hrs of sale) (ATALYA)]@row), TODAY() >= [Date Job Processed (within 24hrs of sale) (ATALYA)]@row + 7), 1, 0)

I think your formula is better to have exact timeline.

Thanks Again 😊

I really appreciate your efforts.

Sid

Hello Neil,

I have encountered another issue. I will appreciate your help.

I want column E to turn Red 24 hours after the column D is populated.

Thanks in advance:)

Neil Watson

@Sid another helper column, with a formula that triggers 24 hrs after the first one? And another set of conditional formats?

Sid

Hello Neil,

Thanks for that:)

Is there a way to ignore weekends and public holidays? So that it does not count the weekends in 24 hours.