I need to conditionally format the range I4:I40 so that;
If any cell within this range is equal to any of the values in the yellow cells in column H then they will be shaded red. If they are not equal they will be shaded green.
the cells highlighted yellow in column H have only been highlighted to demonstrate the cells to look against. They will always be in the same locations but will not necessarily be highlighted yellow. the values of these cells will change.