Copy Conditional Formatting?

H

homer09001

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
 
T

T. Valko

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<>""
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel not recognizing formula 1
More than 1 Variables 1
Convert to Excel Macro 2
Convert to Excel Macro 3
Excel VBA 1
SUMIF help needed 6
conditional formatting 1
Forumla to change values on situation 4

Top