Forum Discussion
Issues with Conditional Formatting Cells dependent on VLOOKUP
Go into manage rules and adjust the applies to box. Included a screen cap for reference (These aren't using your rules. Just a sample).
If you don't extend conditional formatting this way the other ways are using a table or the format painter. The latter has a few nuances. For example, if A1:B1 contain conditional formatting rules, you select those cells, click format painter, then brush the cells to extend - let's say A2:B10.
Thank you for the feedback Patrick. Using the 'Applies To' section will not work for my case because the rule itself would still be checking cells F10 and G10 (I am referencing the equations you wrote out as the original response on this post).
By rolling the rule downward to apply to more cells, I would additionally need the mention of F10 and G10 to roll as well (i.e. one row down the rules would need to change to F11 and G11). I know this is very specific and having the rules themselves actually change is the part that may very well be obtainable in excel, wanted to put it out there just in case.
Also, thank you again on the equation formatting. That really was a huge help for me.
Conditional formatting with a formula and a range of cells is built with the first row in the range in mind. As long as you use correct referencing styles the references to F and G should change accordingly by the row.