08-28-2020 11:45 AM
My spreadsheet has a date of last production in K3
Cell L3 is a simple formula =sum(K3+730) to show me 2 years after K3
I want cell L3 to fill with RED and change font to White Bold Italic if the calculated date in L3 is less than today.
My thought was: IF(L3<TODAY(),xxx with the x's being the part I'm not sure how to do.
Can someone help? Thank you. I'm 69 yrs old and trying to learn more complex formulas to "open my world". I used to tell people on a scale of 1-10 I was a 7 in Excel. Now I tell them I'm a 2. Thanks in advance! - Joe
08-28-2020 12:15 PM - edited 08-28-2020 12:16 PM
SolutionHi how are you doing? I hope I can assist you
What you need is Conditional Formatting
The formula is like the follows
=$L3<TODAY()
08-28-2020 01:16 PM
hi
you need conditional formatting. See the attached spreadsheet where I have inserted the formatting.
08-31-2020 04:53 AM
I completely described the wrong issue. What I in fact need to do is insert a word in Cell J3 if the calculated date is equal to or over 2 years old. Here again is the issue, with corrected text:
My spreadsheet has a date of last production in K3
Cell L3 is a simple formula =sum(K3+730) to show me 2 years after K3
I want cell J3 to populate with the word "Partial" if the date in L3 calculates less than 2 years, or "Full" if the date in L3 is equal to or older than 2 years. I can then use Conditional Formatting to differentiate between "Full" and "Partial". I have attached a sample of what I'm looking for. Sorry for wasting your time the first time.
Joe
My thought was: IF(L3<TODAY(),xxx with the x's being the part I'm not sure how to do.
Can someone help? Thank you. I'm 69 yrs old and trying to learn more complex formulas to "open my world". I used to tell people on a scale of 1-10 I was a 7 in Excel. Now I tell them I'm a 2. Thanks in advance! - Joe
08-31-2020 05:22 AM
Thank you for responding. @Juliano-Petrukio