Hi I would like to make a range of cells within a column turn green when certain conditions are met.
The user will enter "I or "M" in each cell. If certain cells contain I's and certain cells contain M's then all of these cells turn green.
Grateful for any assisstance.