ok i have a 3 column table
column 1is the title column 2 is the genre and column 3 is a persons name

bassicaly this is how i want the formula to work:

IF Cx IS NOT EMPTY FILL BACKGROUND Ax & Bx RED

which translated to excel formula is =ISTEXT(Cx) This formula is applied to
A1 & B1 but i need to apply it to 150+ rows but when i try to copy the
formula down it only changes when C1 has text in it, i want each row to
change colour only when its C column in its row is populated?

Can anyone shed any light on this problem otherwise its a case of writing
this formula in manually for each and every row :S