Forum Discussion
Conditional formatting across sheets
I have a sheet which manages the works of multiple budgets.
One sheet provides an overview of the budget and the next show the various schemes attributed to the numerous budget codes. Currently I have to flip back and forth to see whether the budgets have available monies before progressing a scheme but with a high number of jobs each day this can be quite time consuming.
I would like a formula to format the budget name cell in the second sheet (B:B) when the value in the available budget column (J:J) relative to the specific budget name (B:B) both in the first sheet, is showing as a negative figure.
Does the attached file show your intended result?
This is the rule for conditional formatting for english Excel.
=VLOOKUP(B2,Tabelle1!$B$2:$J$20,9,FALSE)<0
2 Replies
- OliverScheurichGold Contributor
Does the attached file show your intended result?
This is the rule for conditional formatting for english Excel.
=VLOOKUP(B2,Tabelle1!$B$2:$J$20,9,FALSE)<0
- chwar750Copper Contributor
YES! I think so Oliver this is brilliant. Could you paste the formula here, my work computer is very fussy with downloads (so thank you for also providing the screenshot)