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

Select the entire range and do it in one operation.

Assume the range of interest is A1:B150

Select the range A1:B150. Select this range starting from cell A1.

Use this formula:

=$C1<""

--
Biff
Microsoft Excel MVP


"homer09001" wrote in message
...
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