apologies about the image, ive changed it to a document.

I tried the conditional format on column A but they have all turned red, so I'm not sure what Ive done wrong. I use Office 2007 if that makes any difference. The sheet (in case your wondering) is relating to industry in a game called eve online.

EDIT
I can see that cell references are wrong so I changed the formula for the number 3 rather than 1 (as the rows start from cell 3) but it still didn't work.

Hi

See the attached I have put the formulas in column A. See the picture within the spreadsheet for where the "New Rule is entered".

Attached Files

001-BPO Information (2).xlsx (39.3 KB, 12 views)