M
MeatLightning
Hey all -
I'm trying to use the following formula to conditionally format a cell:
=EOMONTH(F14,0)=L3
I basically have a cell in my sheet with "TODAY()" then I have series of
cells (headers for columns G thru AH) that create a timeline based on today's
date using the "EOMONTH" function / formula. For example: Cell "G3" has
"=EOMONTH(A3,-3)", Cell H3 has "=EOMONTH(A3,-2)" etc.
I then have a series of tasks in column A. Each with an end date entered as
"m/dd/yy". I'd like to indicate when a given task is due by formatting the
background color of the appropriate cell.
When I enter =EOMONTH(F14,0)=L3 as the conditional formatting formula, I get
an error message saying "You may not use references to other worksheets or
workbooks for Conditional Formatting criteria."
Any help you could send my way would be much appreicated!
I'm trying to use the following formula to conditionally format a cell:
=EOMONTH(F14,0)=L3
I basically have a cell in my sheet with "TODAY()" then I have series of
cells (headers for columns G thru AH) that create a timeline based on today's
date using the "EOMONTH" function / formula. For example: Cell "G3" has
"=EOMONTH(A3,-3)", Cell H3 has "=EOMONTH(A3,-2)" etc.
I then have a series of tasks in column A. Each with an end date entered as
"m/dd/yy". I'd like to indicate when a given task is due by formatting the
background color of the appropriate cell.
When I enter =EOMONTH(F14,0)=L3 as the conditional formatting formula, I get
an error message saying "You may not use references to other worksheets or
workbooks for Conditional Formatting criteria."
Any help you could send my way would be much appreicated!