Forum Discussion
Issues with Conditional Formatting Cells dependent on VLOOKUP
Rules should be ordered this way:
Yellow: =ISBLANK(K$10) STOP IF TRUE CHECKED
White: =AND(K$10>=VALUE($F10),K$10<=VALUE($G10))
Red: =OR(K$10<VALUE($F10),K$10>VALUE($G10))
Patrick2788 Thank you so much for the response.
I have a follow up question if you don't mind:
I would like to apply these set of rules to a large range of rows (roughly 100), is there a way to "roll" this rule down along multiple cells or would I have to input the rule into each individual cell? The only change in the rules from row to row would be the row number (in the case of your post and my example sheet, the number 10 would be the item in the equations you posted that would be changing per row).
I say roll with quotations because I know excel has the feature that if you type a number into a cell, say 1 for example, and drag the little black box in the bottom right corner of the cell and select "Fill Series" it will chronologically list from the number 1, automatically into the corresponding cells. I have been using the brute force method of inputting into individual cells but obviously that is time consuming and tedious so I would like to avoid doing this if possible