Forum Discussion
chwar750
Oct 03, 2025Copper Contributor
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...
- Oct 03, 2025
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
OliverScheurich
Oct 03, 2025Gold 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
- chwar750Oct 03, 2025Copper 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)