hi,

After some help with a macro.

I have a spreadsheet that tracks staff, in column F the value if either empty, "OK" or other

if a cell in column F1 -> Last Row is empty the cell to its left remains uncoloured, if it is "OK" the cell to the left is green, and if the cells is anything else then the cell to the left should be red.

it works with standard conditional formatting but everytime a new row is inserted it breaks the CF up into more than one rule and over time it gets very clogged up and sometimes breaks.

I've tried to get bits of code of the new to make this myself but im getting no where, so i would greatly appreciate it if someone could create a working macro that does this on the fly.

Much appreciated.