conditional formatting

[Keith]

can i reference a result of a different cell to the cell i'm working in?
example: c1 is my working cell
if (a1=2) then fill c1 with blue

 

[Ms-Exl-Learner]

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 Format>>Conditional Formatting>> For Condition1>>Select '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.

Remember to Click Yes, if this post helps!

 

[Keith]

I figured out the formula for this question. However I have another. 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

 

[Ms-Exl-Learner]

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 Format>>Conditional Formatting>> For Condition1>>Select '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 Condition2>>Select '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!