How Do I Highlight a Cell Based on Conditions of Another?

I want to highlight A1 red if C1 is greater than 55. Is this possible?

Thanks
Ocean

Hi Ocean,

Select cell A1.
On the Home ribbon, click Conditional Formatting -> New Rule...
Select 'Use a formula to determine which cells to format'
In the textbox that appears below that, use the formula:

=C1>55

Click the Format button and set the Fill color to Red.
Click OK twice and you should be set!

Hi,

Try this with Conditional Formatting