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

Place the Cursor in C1 cell and hit Cntrl+Spacebar now the Total C Column
will be selected, keep in mind that the active cell should be Z1 (Active cell
will have a white background after selection also).
Now goto FormatConditional Formatting For Condition1Select 'Formula
Is' Paste the below formula
=$A1=2
Click Format and set your desired formatting (Font Colour & Background) as
per your desire and give Ok twice.

Now Press Add Button, after pressing add button you can able to view
Condition 2:
For Condition2Select 'Formula Is' Paste the below formula
=ISNUMBER($A1)
Click Format and set your desired formatting (Font Colour & Background) as
per your desire and give Ok twice.

The =ISNUMBER($A1) formula will check C1 cell if it consist any number then
it will format the C1 cell with the colour you have defined. It wont colour
the C1 cell if A1 consist Any Text Characters.

If the A1 cell consists the value 2 then the First Rule will be applied.

If you want to highlight the C1 Cell like A1 is having any character then
use this in SECOND CONDITION instead of =ISNUMBER($A1).

Anycharacter (Not Blank)
=$A1<""

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"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

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