I want to implement 2 things at the same time (plz see attached simple table):
1- (Validation list with conditional formatting): Greyout one line item ($) if (Own) is seleceted & vise versa. For example: if (D2=Own), then Land price (rent), & Construction Cost (rent) are greyed out
2- Retreive data/$ from other tab. The question is (how to pull $ into the (unshaded) cell (Land own & cons. Own) & not the greyed out cells & vise versa
Bookmarks