conditional formatting

[copeco]

I have created an order file in excel. Column A(desc),B(size),C(qty). C is normally blank. When something eg(1, 1 bx, 1 cs)is entered in C? the A?,B?,C? row should turn a different color.
Using conditional formatting in column:
C? : cell value is not between ="" and =""zzz""
A?,B?: formula is =C?<&quot;&quot;
With the C? I can use a number-letter combo & get C to change colors.
With the A?,B?, formula I can use a number only eg(1,5,3)to get them to change colors.
So no BX,CS,EA can be used..
**How do I get the entire A?,B?,C? row to change colors with number-letter combinations?

 

[acron]

Try the following :

If you want to start with Row 2, select the entire row. Do Format, Conditional Formatting, and for Condition 1 click on the dropdown an select Formula Is. Enter

=NOT(ISBLANK($C2)),

and set the formatting you want.

Copy the formatting to the remaining rows.

A.C.