Hi All,
I'm looking to apply conditional formatting to a list of cells so that they change colour if that same value occurs on a separate sheet. This is easily done with a vookup in the conditional formatting field.
The complication is that I want to apply an additional condition that says that the formatting should only occur if, in addition to the cell value cropping up on the separate sheet, a separate column in the initial sheet is also equal to a predefined value.
I've been trying to use the following formula in conditiona formatting to no avail.
Here the 'High estimators' is the second sheet, and C10 is the adjacent cell.
=AND((VLOOKUP(N11,'High estimators'!$G$11:$G$15,1,FALSE)),(C10="RF"))
Can anyone suggest a modification to make this work? or perhaps an alternative approach completely. And secondly, if you can crack this, can you advise how to apply this same formula to every cell in my list (the complication here is that, the N11 will need to increase by 1 each time, as will C10)
Thanks!
Jack
Bookmarks