Forum Discussion
Katie Garcia
Apr 09, 2018Copper Contributor
Conditional Formatting Help
In the attached workbook, the cells in Column G are already conditionally formatted for font color. But I'd like rows with code "V" in Column D to fill Column G cells blue or green font (based o...
Katie Garcia
Apr 10, 2018Copper Contributor
I see that this works in the workbook you attached, but it's not working in my file. In my file, the black font in the "V" fill rule that you added negates the font color rules that come after it. So I get the fill correctly, but not the font colors.
The cells in my file in columns E, F & G contain formulas that reference other sheets in the workbook. So they're not just straight text. Could this be affecting the outcome?
It seems like I need formulas that are specific for fill and font at the same time, with two versions for each font color:
If $D2="V" and OR($E2=0, $E2="") happen at the same time, fill is teal and font green.
If $D2="V" and =$E2>0 happen at the same time, fill is teal and font blue.
If $D2="C" and OR($E2=0, $E2="") happen at the same time, fill is white and font green.
If $D2="C" and =$E2>0 happen at the same time, fill is white and font blue.
How do I make those into formulas that work?
The cells in my file in columns E, F & G contain formulas that reference other sheets in the workbook. So they're not just straight text. Could this be affecting the outcome?
It seems like I need formulas that are specific for fill and font at the same time, with two versions for each font color:
If $D2="V" and OR($E2=0, $E2="") happen at the same time, fill is teal and font green.
If $D2="V" and =$E2>0 happen at the same time, fill is teal and font blue.
If $D2="C" and OR($E2=0, $E2="") happen at the same time, fill is white and font green.
If $D2="C" and =$E2>0 happen at the same time, fill is white and font blue.
How do I make those into formulas that work?
Tomasz Kocur
Apr 11, 2018Brass Contributor
Hi Karie
Doesn't matter whether you have formulas in columns E, F, G
Please try below
1. Check whether another conditional formatting is in the range you are working on
2. Play with the order of rules appearance in conditional formatting Rules Manager (see Photo attached)
I would be able to advise more if I could see the source file
Let me know if you still have the issue
- Katie GarciaApr 11, 2018Copper ContributorI removed all the formatting for the column and started over. I was able to make it effective it by using the following formulas:
=AND($D2="V", OR($E2=0, $E2="")) filled teal with green font
=AND($D2="V", $E2>0) filled teal with blue font
=OR($E2=0, $E2="") filled white with green font
=$E2>0 filled filled white with blue font
Thanks for your help!