I *hope* you didn't manually type in all those CF cells. You don't have to do
that.

You just need to highlight all the cells that will use this CF, open the CF
window and enter the formula but remove the $ flags, so $B$24 (absolute
reference) becomes just B24 (relative reference). Now Excel will adjust the
reference for each of the cells highlighted FOR you.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"tlc" wrote:

Dear David and JB,

Great help from you both. I finally overcame my 'operator error'. I
realized the cell B24 was merged with A24 and C24 making the correct entry
=$A$24=....
I also discovered that both versions formatted every one of the cells B19 -
B23 if the condition appeared in just one. Thanks to your help and insight,
I figured out I needed to conditional format each cell individually to change
only the cell with the over .5 entry and cf cell A24 "Quote in...." to even
better results than I had hoped
Now it works to perfection!

Thank you both so very much.
Your help is so very much appreciated. :-)
--
Ever so greatful,
tlc