Thanks,
When I try that, the cells are all highlighted yellow regardless of what's inside of them (or pink if I put that rule higher on the list), I tried it both with the $ or without it.
Some other things that may or may not be pertinent?
- Some of the values produced in the cells by the cells' formulas are negative, but they are all integers.
- My Excel is set up to use the European style with semi-colons instead of commas, which I think you already figured out.
- The cells I'm trying to highlight are in columns AQ through BN; each column's formulas start in row 3 (rows 1–2 are headers for each column).
- The cell formulas in each column reference two different other columns: one of AK through AP and DI, but all of the cells in each column reference the same one of AK through AP. (Why a particular cell has one of the three different formulas in it comes from external data and isn't referenced in the sheet.)
- Each column right now has its own set of conditional formatting in the rules, and their effects are limited to that column (ex. the highlighting that talks about the formulas in column AZ have "=$AZ$3:$AZ$1048576" in the "Applies to" section of the Conditional Formatting Rules Manager), but only because given everything else, I thought I had to limit them this way.
Thanks again for all your help.