Conditional Formatting Based On Another column

[jrusso]

I want column A values to be red text if column C has -2.45 or any other - in front of a number in Column C

Thanks

 

[oldbrewer]

in A1
formula
=C1<0

 

[Joe4]

So, for each row, you want column A highlighted red if the corresponding value in column C is negative?
If so, one way is to select column A and use the following Conditional Formatting formula:

=$C1 < 0

and choose the red formatting color.

 

[jrusso]

Thanks men!