Forum Discussion
Solved
Lookup formatting issue when new row added to table
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 tabl...
- I was able to solve the problem by making the formula =IF(LOOKUP(3,1/($G9:$G10<>""),$G9:$G10)=0,"PAID",IF(OR($G4="",$G4>=TODAY()),"ACTIVE","EXPIRED")) into an array. Now the font formatting doesn't change when adding a new row.
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?
I was able to solve the problem by making the formula =IF(LOOKUP(3,1/($G9:$G10<>""),$G9:$G10)=0,"PAID",IF(OR($G4="",$G4>=TODAY()),"ACTIVE","EXPIRED")) into an array. Now the font formatting doesn't change when adding a new row.