Forum Discussion

Katie Garcia's avatar
Katie Garcia
Copper Contributor
Apr 09, 2018

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 on the existing rules) with a teal fill.  Lines with code "C" in Column D should fill Column G cells with blue or green font (based on the existing rules) but with no fill.

 

How would I adjust the existing conditional formatting rules to include these fill conditions?

 

Thanks!

Formulas & Functions
Need Help

4 Replies

  • Tomasz Kocur's avatar
    Tomasz Kocur
    Brass Contributor
    Apr 10, 2018

    Hi Katie

     

    Please see below

    for value "C" you don't have to put anything because it will not change the cell anyway however, if you need hid any cells that have been manually coloured put it as below

     

    (for some reason can't upload the photo please see the file)

    • Katie Garcia's avatar
      Katie Garcia
      Copper Contributor
      Apr 10, 2018
      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?
      • Tomasz Kocur's avatar
        Tomasz Kocur
        Brass Contributor
        Apr 11, 2018

        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 

Resources