My spreadsheet has a moderately big array (approx 80 rows by 10 columns) where each cell contains, by default, a formula. Users can over-ride the existing formula by entering a numerical constant.
I want to use conditional formatting to shade any cell that contains a constant rather than a formula, so that changed cells can be seen at a glance. I can do this OK for any individual cell, but I'd like to avoid having 800 separate conditional formatting rules, one per cell, all essentially identical but each referring to a different cell. (Reason? I'd like to be able to change the shading color without having to edit 800 different rules!) I can't see a way do this - grateful for any guidance!
Bookmarks