This is a discussion on Conditional formatting based on a different cell within the Excel Questions forums, part of the Question Forums category; I would like to apply conditional formatting to several cells depending upon the value of a single (different) cell... Is ...
I would like to apply conditional formatting to several cells depending upon the value of a single (different) cell... Is this possible without code?
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.Originally Posted by Max Girth
Make the font in A1 change to red if J1=>0
Without putting a formula in a1...
There's already one there.[/quote]
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)
Select A1 | Format | Conditional Format
select "Formula Is"
Then set what formatting you want.
Thank you DRJ
That's better.Originally Posted by Max Girth
Activate Format|Conditional Formatting.
Choose Formula Is for Condition 1.
Enter the following in the white box:
Activate the Format button.
Select red as Color from the Font tab.
Click OK, OK.