changing Text color in on cell based on another.

[Zac]

C22 istarts out blank.
If a number is entered I want A22 thru R22 to change to a Red Font.

I tried this in A22 but nothing happened when I entered a number in C22

="c22>0"

What did I due wrong under Cond Formating (Formula is)

 

[bjwillingham]

Try =not(isblank(c22)) or =isnumber(c22)

Remember the format formula is relative. If you want all cells to refernce c22 use $c$22 in the formula.

 

[WillR]

Formula is =ISNUMBER($C$22) for the range A22:R22

 

[Zac]

I also tried

=IF(C22>0,4,0)

And that seemed to work. Luck????

 

[Iridium]

Try a cond. format of 'Formula is' =$C$22<>0

 

[WillR]

C22 starts out blank.
If a number is entered.......

Try a cond. format of 'Formula is' =$C$22<>0

Surely 0 is a number ?

 

[bjwillingham]

Who is Shirley and what does she have to do with zero?

 

[Iridium]

C22 starts out blank.
If a number is entered.......

Try a cond. format of 'Formula is' =$C$22<>0

Surely 0 is a number ?

Doh! You're right Will.

Zac - replace the 0 with ""

 

[WillR]

Brad.... you mean you've never met "shirley 0"

 

[Zac]

U r all out of control.

If Shirley was a 0 none of you would be discussing her. LOL