Conditional formatting based on another cell?

Closed

JTTaylor92 Posts 1 Registration date Thursday January 19, 2017 Status Member Last seen January 19, 2017 - Jan 19, 2017 at 08:42 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Jan 23, 2017 at 12:07 PM

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!

Excel format cell based on another cell
How to change date format in excel - Guide
Excel clear formatting - Guide
Excel multiple lines in one cell - Guide
Conditional formatting based on another cell text - Excel Forum
Excel cell color formula - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
Jan 23, 2017 at 12:07 PM

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

Similar discussions

Clear cell contents based on value of another cell range using VBA

help me to add particular cells

If a cell contains any text then add a value

Conditional Format Cells Based on Another Cell and Own Cell

Return Seq Values Until Blank value then return different set of seq values

Similar discussions

Subscribe To Our Newsletter!