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

[Rainbow]

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?

 

[Andrew Poulsom]

Can't you reference that workbook in a formula in a spare cell and use that cell in Conditional Formatting?

 

[ExcelMercy]

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]

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]

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]

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]

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.