akshatk1991
New Member
- Joined
- May 6, 2013
- Messages
- 13
So i have a formula which reads like this
=IF(((INDEX(RSheet1!A$4:$H$108,MATCH(Sheet1!BL$6,Sheet1!$A$4:$A$156,0),MATCH(Sheet1!B$21,Sheet1!A$4:$H$4,0)))=0,forecast($C$6:$BK$6,$C$21:$BK$21,BL6),((INDEX(Sheet1!A$4:$H$108,MATCH(Sheet1!L$6,Sheet1!A$4:$A$156,0),MATCH(Sheet1!B$21,Sheet1!A$4:$H$4,0)))
So basically, if the first data is available, it uses it, and if its not available, it uses the secondary formula. Now i need to format the cells such that the user knows when a forecast is used, or when the actual data is used. Is there any way to use conditional formatting for this purpose or vba?
=IF(((INDEX(RSheet1!A$4:$H$108,MATCH(Sheet1!BL$6,Sheet1!$A$4:$A$156,0),MATCH(Sheet1!B$21,Sheet1!A$4:$H$4,0)))=0,forecast($C$6:$BK$6,$C$21:$BK$21,BL6),((INDEX(Sheet1!A$4:$H$108,MATCH(Sheet1!L$6,Sheet1!A$4:$A$156,0),MATCH(Sheet1!B$21,Sheet1!A$4:$H$4,0)))
So basically, if the first data is available, it uses it, and if its not available, it uses the secondary formula. Now i need to format the cells such that the user knows when a forecast is used, or when the actual data is used. Is there any way to use conditional formatting for this purpose or vba?