As i posted previously I have a table set up, where a task for a week
gets a one if completed of left blank if not. I would now prefer it to
have intials in place like DS for example and for the formula still to
work as it did previously.

=TODAY()-LOOKUP(1,B3:BA3,$B$2:$BA$2)=14 This formula is used in the
conditional format option for the task, it highlights the task in red
if a 1 hasn't been placed next to a date for two or more weeks. So
task2 will light up in this example:

December January
4 11 18 25 1 8 15 22 29
Task1 1 1 1 1
Task2 1
Task3 1 1 1 1
Task4 1 1 1 1

I changed the formula to =TODAY()-LOOKUP(DS,B3:BA3,$B$2:$BA$2)=14
without success. can text types be used for such an issue?

Hi Dave

Text needs to be inside quotation marks in a formula. "DS"

Cheers!
Jean-Guy

"Dave" wrote:

As i posted previously I have a table set up, where a task for a week
gets a one if completed of left blank if not. I would now prefer it to
have intials in place like DS for example and for the formula still to
work as it did previously.

=TODAY()-LOOKUP(1,B3:BA3,$B$2:$BA$2)=14 This formula is used in the
conditional format option for the task, it highlights the task in red
if a 1 hasn't been placed next to a date for two or more weeks. So
task2 will light up in this example:

December January
4 11 18 25 1 8 15 22 29
Task1 1 1 1 1
Task2 1
Task3 1 1 1 1
Task4 1 1 1 1

I changed the formula to =TODAY()-LOOKUP(DS,B3:BA3,$B$2:$BA$2)=14
without success. can text types be used for such an issue?

Try enclosing your DS in quotes, like "DS"

Vaya con Dios,
Chuck, CABGx3



"Dave" wrote:

As i posted previously I have a table set up, where a task for a week
gets a one if completed of left blank if not. I would now prefer it to
have intials in place like DS for example and for the formula still to
work as it did previously.

=TODAY()-LOOKUP(1,B3:BA3,$B$2:$BA$2)=14 This formula is used in the
conditional format option for the task, it highlights the task in red
if a 1 hasn't been placed next to a date for two or more weeks. So
task2 will light up in this example:

December January
4 11 18 25 1 8 15 22 29
Task1 1 1 1 1
Task2 1
Task3 1 1 1 1
Task4 1 1 1 1

I changed the formula to =TODAY()-LOOKUP(DS,B3:BA3,$B$2:$BA$2)=14
without success. can text types be used for such an issue?

Ok thanks CLR, can't beleive I didnt try that simple thing!!!

CLR wrote:

Try enclosing your DS in quotes, like "DS"

Vaya con Dios,
Chuck, CABGx3



"Dave" wrote:

As i posted previously I have a table set up, where a task for a week
gets a one if completed of left blank if not. I would now prefer it to
have intials in place like DS for example and for the formula still to
work as it did previously.

=TODAY()-LOOKUP(1,B3:BA3,$B$2:$BA$2)=14 This formula is used in the
conditional format option for the task, it highlights the task in red
if a 1 hasn't been placed next to a date for two or more weeks. So
task2 will light up in this example:

December January
4 11 18 25 1 8 15 22 29
Task1 1 1 1 1
Task2 1
Task3 1 1 1 1
Task4 1 1 1 1

I changed the formula to =TODAY()-LOOKUP(DS,B3:BA3,$B$2:$BA$2)=14
without success. can text types be used for such an issue?