conditional formatting excel 2010

SDKBRK

Board Regular
Joined
Feb 1, 2003
Messages
162
I just got 2010 Excel so I'm struggling. I want to put a conditional format in cell X11. If cell AD11 has an X change the color of cell X11. I can not seem to get it. Please help ........
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

misrasomendra

Board Regular
Joined
Nov 17, 2012
Messages
74
Hi,

From the Home Tab Select CF drop down, select New Rule, Select the option Use a formula to determine.... Than in Formula Box put =AD11="X", select the format.

Select Cell X11 before doing this.
 

SDKBRK

Board Regular
Joined
Feb 1, 2003
Messages
162
That was way to easy. I was thinking way to hard. Thank you.
One more question.
If AD11 was a color and if it was like yellow. How would I write the formula. If AD11=YELLOW turn X11 yellow.
 

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,211
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
That was way to easy. I was thinking way to hard. Thank you.
One more question.
If AD11 was a color and if it was like yellow. How would I write the formula. If AD11=YELLOW turn X11 yellow.
You can't use the color in a cell to conditionally format another cell, but if cell AD11 is colored yellow by conditional formatting, you can use the same CF rule applied to AD11 on X11 so it will turn yellow whenever AD11 turns yellow.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,032
Messages
5,526,358
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top