Excel conditional formatting for one cell

In Excel, I have a cell with text C16
I want to apply conditional formatting: if cell G16 contains a value greater than or equal to 2, color the text in C16 red

Thanks for your help!
JohnD
LVL 1
John DarbyPMAsked:
Who is Participating?
 
Ares KurkluConnect With a Mentor Software EngineerCommented:
You need to  select C16
go to Contional formatting
use "Use a formula to determine which cells to format"
then = $G$16> 2
go to format and pick the colour red
1
 
Ares KurkluSoftware EngineerCommented:
You can simply go to Conditional Formatting create a new rule there.
0
 
John DarbyPMAuthor Commented:
Understood, I just don't seem to be able to create a formula that works :)
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Bill PrewConnect With a Mentor Commented:
Select c16, then click on conditional formatting, select the bottom "by formula" option, use a formula of

=$G$16>=2

and then select the formatting you want applied below that.  Save it.


»bp
1
 
John DarbyPMAuthor Commented:
Thank you so much!
0
 
Bill PrewCommented:
Welcome.


»bp
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.