Forum Discussion
Conditonal Formatting
Hi, I am trying to add conditional formatting to my worksheet.
In column, A there is the date
In column B, there is Money going in
In column C, there is money going out
in column D, there...
Hi Aisha,
You may expand your rule for D if use in rule formula absolute reference for cell in D like $D2 and apply this rule to combined region like $D$2:$D$100,$B$2:$B$100
- Thank you for your suggestion
I'm sorry, I do not understand the excel formulas. Am I able to copy and paste what you have suggested or do I need to alter it? If I need to alter it, is there a help document you could suggest? Thank you!Hi Aisha,
How to use formulas with conditional formatting is here https://support.office.com/en-us/article/use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f and in many other sources.
For such sample
we create two rules for two colors applying them to your columns from B to D (in ribbon Home->Conditional Formatting->New Rule->Use formula to determine which cells to format).
Formulas are
just be careful with absolute and relative references.
And attached
