Hey, I just solved a little question in Conditional Formatting that I had and thought other loungers might find the solution useful as well. I was fooling around with a scenario where I wanted conditional formatting to highlight if a linked value from another spreadsheet was zero (indicating that data hadn't yet been entered into the spreadsheet).
Then I ran into the problem that Conditional formatting will not accept references to another sheet or workbook.Solution: Give the cell a range name, use the range name in your formula and then reference the range name in Conditional Formatting condition.