Forum Discussion

chwar750's avatar
chwar750
Copper Contributor
Oct 03, 2025
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 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.

 

 

2 Replies

    • chwar750's avatar
      chwar750
      Copper 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)

Resources