extend conditional formatting

gertie1208

New Member
Joined
Dec 2, 2016
Messages
3
Hi.

I'm trying to extend my conditional formatting to the entire spreadsheet.

i'm using a formula: =not(isblank(b13))
I'm putting that conditional formatting on A13.

Is there a way to get it easily to all the rows in the spreadsheet? the entire row can be filled, it doesn't need to be just the A cell...

Thanks in advance.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

63falcondude

Well-known Member
Joined
Jan 15, 2016
Messages
3,572
A few ways:

1) Click on A13, then select conditional formatting, Manage Rules, change the "Applies to" to whatever you want.
2) Click on A13, click on format painter, left click and drag the mouse to select all other rows that you want to be conditionally formatted as well.
 

gertie1208

New Member
Joined
Dec 2, 2016
Messages
3
i should have been more clear, my apologies.

I need a14 to be conditionally formatted with the fomula =not(isblank(b14))
a15 to be conditionally formatted with the formula =not(isblank(b15))

and so on.

is there a way to not have to make the conditional formatting for each and every row?

Thanks.
 

63falcondude

Well-known Member
Joined
Jan 15, 2016
Messages
3,572
i should have been more clear, my apologies.

I need a14 to be conditionally formatted with the fomula =not(isblank(b14))
a15 to be conditionally formatted with the formula =not(isblank(b15))

and so on.

is there a way to not have to make the conditional formatting for each and every row?

Thanks.

Have you tried my suggestions? That is exactly what they do.
 

gertie1208

New Member
Joined
Dec 2, 2016
Messages
3
it did work! it just highlights everything when i do that...but then i can hit delete in the b column and it starts working correctly...

weird. but thanks!
 

63falcondude

Well-known Member
Joined
Jan 15, 2016
Messages
3,572
it did work! it just highlights everything when i do that...but then i can hit delete in the b column and it starts working correctly...

weird. but thanks!

You're welcome. Did that solve it for you? It should highlight every row in column A where the corresponding row in column B is not blank.
 

Watch MrExcel Video

Forum statistics

Threads
1,133,538
Messages
5,659,384
Members
418,500
Latest member
Guru Prasad S

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top