Conditional Formatting for Entire Row.

[admirable]

Hello Everyone!

I'm using MS Excel 2013 and I need to know how to use Conditional Formatting Color for Entire Row.

Lets Suppose...
Cell E7 is No Blank functioned then an specific Color should be apply on Entire Row7.

I able to use Conditional Format for singe cell with (No Blank) function but unable to use it for Entire Row.

So Help me to solve this issue.

[ChristopherHac]

CLick in cell that has the rule already applied, click conditional formatting, click manage rule, and change 'applies to' for the row

[admirable]

Did not work.

[admirable]

Anyone Please Help me to Solve my issue...

[FDibbins]

1st (and this is aimed at Christopher), you should avoid applying CF to entire rows....CF tends to be fairly resource-intensive, and if you have a considerable amount of rows, it will begin to start slowing your file down. In most cases, all you need to do is highlight the required range, notthe entire row

Having said that...
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$E7<>"" format fill as required

[admirable]

1st (and this is aimed at Christopher), you should avoid applying CF to entire rows....CF tends to be fairly resource-intensive, and if you have a considerable amount of rows, it will begin to start slowing your file down. In most cases, all you need to do is highlight the required range, notthe entire row

Having said that...
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$E7<>"" format fill as required

It did not work.... :-(

[FDibbins]

I just tested it again and it worked fine. what "didnt work"?

Note that if row 7 is NOT the 1st row that you are applying the CF to, then change the $E7 to whichever row you start in, and dont forget to include the $

[admirable]

I just tested it again and it worked fine. what "didnt work"?

Note that if row 7 is NOT the 1st row that you are applying the CF to, then change the $E7 to whichever row you start in, and dont forget to include the $

I have tested this for many times but all in vain, can you please give me a favour, just attach the file here for sample.