Hi All,
I am looking for a way to highlight a cell with Conditional Formatting when it meets certain requirements.
So in the attached file i have a budget overview (adjusted version) with Supplier budgets per month. Now only January showing.
Now as you can see there is a 100 euro budget in January (C3) for Supplier_A (A3) and nothing for Supplier_B (A4), so its Supplier_A that is interesting. What i want to achieve is the following:
I want cell A3 to be automatically highlighted during the real life month January as there is a budget filled in for that month under cell C3. Cell B1 has the formula =MONTH(A1) showing the current month and cell C1 has "January" as text so that should be a match.
Hopefully somebody can tell me if this is even possible.
Bookmarks