Conditional formatting based on another cell? [Closed]

Report
Posts
1
Registration date
Thursday January 19, 2017
Status
Member
Last seen
January 19, 2017
-
Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
-
Hi everyone! I'm trying to finish my financial sheet to work out where I am for this year. I need it so that when I type in the word "yes", It shows the cell to the left as yellow. I've tried so many formulas and so many help pages without luck! Please help me?..
Im on Mac Excel 2011.

Thank you in advance!

1 reply

Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
448
Hi JTTaylor92,

Select D3.
Open conditional formatting and choose to use formula.
=$E3="Yes" apply format.
Used range:=$D$3:$D$14

Here is a pic for clearification:


Not sure though, if this is any different for using a mac.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!