I have attached a sample and have manually colored the cell according to how the formula needs to work.
Condition 1; If the information is coming from column 92 fill color needs to be blank if greater than today, if less than today s/b red. (92 is a forecast date)
Condition 2: If the information is coming from column 93 fill color needs to be green. (93 is a actualized or completed date)
=IF(COUNTIF(Sheet2!$E$4:$FV$100,$A19)=0,"",IF(VLOOKUP($A19, Sheet2!$E$4:$FV$100,93,FALSE)="",VLOOKUP($A19, Sheet2!$E$4:$FV$100,92,FALSE),VLOOKUP($A19,Sheet2!$E$4:$FV$100,93,FALSE)))
Thanks in advance for any and all suggestion.
Snickers
Bookmarks