Forum Discussion
Solved
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 ha...
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
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
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)