Reference to another worksheet for Conditional Formatting

[excel71]

Hi All,

Just for keeping things as clean as possible in my file, I would like to use conditional formatting with a reference to a cell that is in another sheet, however Excel does not allow that. Is there a way around to do this?

Thanks!

 

[VoG]

Yes. You can create a named range to refer to the allowable entries.

 

[excel71]

Thanks! That worked.