Change color of cell with formula

[Oeysbrei]

Hi,

I need a formula that makes a cell change color when another cell returns a value.

Example:

A1=1 (I want A2 to turn black)
A1=Blank (No changes in A2)

Best regards
Øystein

[sandy666]

try =ISNUMBER($A$1) in CF with Applies to: =$A$2

[Oeysbrei]

Thanks for youre response sandy666, but I dont understand what you mean about this formula. Is it possible for you to post a file that contains what im asking for?

Best regards
Øystein Breivik

[sandy666]

1. select A2
2. open Conditional formatting
3. New rule, use formula to determine which cells to format
3. format values where this formula is true: =ISNUMBER($A$1) (på norsk: =ERTALL($A$1)
4. select color (black)
5. ok
now try in A1 = X then A1 = 5

[Oeysbrei]

Hi sandy666,

You have probably explained it god, but I still dont understand how to do this.
What is "Conditional formatting" and "New rule"?

Best regards
Øystein Breivik

[sandy666]

see this (and change ISNUMBER to norsk version)

[JeteMc]

[Where are] 'conditional formatting' and 'new rule'?
The conditional formatting icon is found on the 'Home' tab in the 'Styles' pane. Selecting the conditional formatting icon opens a drop down and new rule is the third option from the bottom.
In the attached file cell A2 is selected. If you enable editing and select conditional formatting > manage rules (last option) you'll see Sandy's formula applied.
Let us know if you have any questions.

[sandy666]

Another way:
Select A2 and next
Alt + H, L, N, then down arrow to the end, TAB, =ERTALL($A$1) , TAB, Enter, Click Black, Ok, OK

[sandy666]

Thanks for the feedback and marking thread as solved, but never delete description/question from the first post because all answers has non sense if you do that.
If you can bring it back.

[Oeysbrei]

Hi sandy666,

I dident know that I changed the first post, but now it should be ok I did something wrong when I should mar it solved.

Regards
Øystein

[sandy666]

No problem if now it's ok
If you mark thread solved (top right corner - thread tools) you don't need edit your first post because you are an owner of this thread. If you can't do that by yourself you can ask mod to do that. (mod - moderator)
It's a good to know that for the future
Have a nice day.

btw. If you don't know how to do something with post go to Test Forum and try