Dec 18 2021 04:23 PM
Have made great progress creating a file to track contracts, and other than the file changing the hyperlinks twice (grrrrr....) the only (current) issue I have is with a lookup command and Excel tables.
I have a field to show the status of the contract - Active, Paid, or Expired, which changes the color of the contract header based on the status. If the contract tracks the payments made then it uses a table. The status references the last cell in the Balance column of the table to find if the balance is zero and therefore mark it as paid. It works great except for an issue of when a new row is added to the table the status cell adopts the format of the table (Calibri 11, black).
The formula is: =IF(LOOKUP(3,1/($G9:$G10<>""),$G9:$G10)=0,"PAID",IF(OR($G4="",$G4>=TODAY()),"ACTIVE","EXPIRED"))
Why is it doing that and how do I get it to not do that? Any help would be greatly appreciated!!
Using Excel 2019 on a Win10 pc. (I would attach a file, but don't see any way to do so?)
Dec 18 2021 10:56 PM
@stuckonweb I remembered helping you with this schedule a while ago and found that the issue at the time was related to conditional formatting. Did you change anything in that area?
Dec 19 2021 12:17 AM
Jan 18 2022 05:36 AM
SolutionJan 18 2022 05:36 AM
Solution