wrote:

3. From the first drop-down list, choose Formula Is

Which should be the default. I use Conditional Formatting all the time. But
I have never used the default Cell Value Is.

Don <www.donwiss.com (e-mail link at home page bottom).