Good time of the day to you all!
I have a problem with conditional formatting and really hope that someone could help
In the below table the formatting needs to be applied to the columns D, E, F
and it should be based on the values in columns A & C with the following condition:
* if cell D4 >= cell A4, cell D4 needs to turn green
* if cell D4 <= cell C4, cell D4 needs to turn red
* if cell D4 =AND(D4<A4, D4>C4), cell D4 needs to turn yellow
These 3 rules should be applied to all cells in columns D, E, F. However when I select for example column D4:D17 and set the above rules in the conditional formatting section, the colors are applied in the end, but only green and red, and it is also showing wrong colors (you can see it in the file attached).
I feel like I am missing something, an additional condition maybe or the order of the rules... I have tried to tweak the formulas, use $$ on the cells from columns A & C, but nothing seems to work.
Below I pasted a photo of the table and I also added a file where you can see the table and the conditional formatting rules that I have applied.
I would really appreciate any help, and please tell me if I didn't explain myself well and I will try again.
1600432920656.png
Many many thanks!
Bookmarks