Reference Other Work Sheets for Conditional Formatting

While it's true you cannot reference other worksheets or workbooks directly in a conditional format formula, you can use a named range that refers to another location.

For example, let's say you want to change the background color of cell A1 on Sheet1 if the value in cell B1 on Sheet2 was greater than 5.

Go to cell B1 on Sheet2 and click Insert > Name > Define (or in Excel 2007, go to the Formula ribbon bar and click Define Name). Create a name for that cell (try to avoid spaces or special characters, generally). Let's say you named it: Sheet2B1

Now, go to cell A1 on Sheet1 and open the Conditional Formatting window. Add a conditional format such that the 'Formula Is' =Sheet2B1>5

That should do it!

Kinna,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.