Try conditional formatting condition1 formula; after selecting cell C1

=AND(A1<"",A1<2)

--
Jacob


"Keith" wrote:

Thanks Ms-Exl-Learner on my previous post. Related question.

I enter 2 into a1 cell and c1 fills with blue. If I enter 3 into a1 then c1
changes
back. How can I keep c1 blue while entering something different than 2 into
the a1 cell