select the block to be conditionally formated and enter the formatting for all


"Paul" wrote:

How do I paste conditional formats WITHOUT pasting the borders, pattern, etc.
? Also, I want to be able to post the conditional formats with the 'usual'
use of $ in the formula.