Can conditional formatting be dependent on a cell in another workbook?

Rainbow

Board Regular
Joined
Oct 3, 2003
Messages
65
I would like to make a cell D25 Red if cell L362 in workbook 2014 Master DS Alignment.xlsx worksheet 2014 Alignment had "2nd Airing" in it.

Can this be done?
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Can't you reference that workbook in a formula in a spare cell and use that cell in Conditional Formatting?
 

ExcelMercy

Board Regular
Joined
Aug 11, 2014
Messages
151
Conditional Formatting -> New Rule -> Use a Formula to Determine which Cells to Format


Format values where this formula is true:
=SheetName!L362="2nd Airing"

Applies to:
=D25

Format:
Red
 

Rainbow

Board Regular
Joined
Oct 3, 2003
Messages
65
Can't you reference that workbook in a formula in a spare cell and use that cell in Conditional Formatting?

I could but I really want to look at every cell on a work sheet and then apply it to the corresponding cell on the other sheet.
I think ExcelMercey's solution may work better and it looks like something I can apply to the whole worksheet.
I'll have to try it when I get a little caught up.
 

Rainbow

Board Regular
Joined
Oct 3, 2003
Messages
65

ADVERTISEMENT

Conditional Formatting -> New Rule -> Use a Formula to Determine which Cells to Format


Format values where this formula is true:
=SheetName!L362="2nd Airing"

Applies to:
=D25

Format:
Red

I tried this and got the following error message...
"You cannot use references to other worksheets or workbooks for Conditional Formatting criteria."



I'm trying to use a cell from not only another worksheet, but another workbook.
Is that the problem?
 

ExcelMercy

Board Regular
Joined
Aug 11, 2014
Messages
151
Yea, as far as I'm aware there isn't a way to apply Conditional Formatting to other workbooks. Can you bring the data into the same workbook? Just move to a separate sheet / hide if necessary?
 

Rainbow

Board Regular
Joined
Oct 3, 2003
Messages
65
Yea, as far as I'm aware there isn't a way to apply Conditional Formatting to other workbooks. Can you bring the data into the same workbook? Just move to a separate sheet / hide if necessary?

Not really.
This one work book pulls information from 4 different work books and those need to stay separated because they are 4 different shows that I'm aligning.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,962
Messages
5,599,065
Members
414,281
Latest member
Engjamal2021

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