Conditional formatting based on a different cell

[Max Girth]

I would like to apply conditional formatting to several cells depending upon the value of a single (different) cell... Is this possible without code?

 

[Aladin Akyurek]

Yes.

 

[Max Girth]

Can you elaborate?

 

[Aladin Akyurek]

Can you elaborate?

Why me? It's, as far as I know, not me who wants to cond format several secret cells depending upon again a secret cell while no condition specified.

 

[Max Girth]

hmmm...

OK...
Make the font in A1 change to red if J1=>0
Without putting a formula in a1...
There's already one there.[/quote]

 

[DRJ]

In conditional formatting select "Formula Is" then put in the formula you want.

So in cell D7 if you wanted it to be conditionally formatted if A1 = 5 then put

"Formula Is" =if(A1=5,True,False)

 

[DRJ]

Select A1 | Format | Conditional Format

select "Formula Is"

=If(J1>=,True,False)

Then set what formatting you want.

 

[Max Girth]

Thank you DRJ

 

[Aladin Akyurek]

hmmm...

OK...
Make the font in A1 change to red if J1=>0
Without putting a formula in a1...
There's already one there.

That's better.

Activate A1.
Activate Format|Conditional Formatting.
Choose Formula Is for Condition 1.
Enter the following in the white box:

=(A1<>"")*($J$1>0)

Activate the Format button.
Select red as Color from the Font tab.
Click OK, OK.

 

[DRJ]

Your welcome.

Take Care