VBA code required
i want values in column "K" based on the Values in column "G"...ie
column G Column K
<3500 OK
>=3501 & <4500 OA
>=4501 & <5500 OA&NE
i also want that whn value of column K becomes "OK" then the fill color of the cell become Green , and if it is OA then it is Blue and if it is OA&NE then it is red.
Bookmarks