Conditional Format One Cell Based on Another Cell

[MikeDBMan]

How do I do conditional formatting for one cell based on data in another cell. For example if the cell in the "Type" column says "Intercompany" I wish the Project Number to be a certain prominent color. Thanks.

 

[VoG]

See for example http://www.mrexcel.com/forum/showthread.php?t=528039

 

[MikeDBMan]

I am using Excel 2010 and I could not figure out how to make the examples in that link work with my version of Excel. Any other ideas?

 

[VoG]

Home Tab > Conditional Formatting > New Rule > Use a formula...

 

[MikeDBMan]

So if I wish Column A's Data to appear with Red background if Column AL's contents for that row is "Intercompany", what would the formula be? I cannot figure that part out. Thanks.

 

[edokhotnik]

Select Column A

Home Tab > Conditional Formatting > Use a formula > New Formula

=AL1="Intercompany"

Choose your formatting. Should work.

 

[VoG]

Select A1 as far down as you need then apply the CF formula

=AL1="Intercompany"

 

[MikeDBMan]

That solved the problem! Just an FYI for others who may read this. My data was in a table. So instead of referring to $AL1, I had to refer to $AL2 or the formatting was off one row. Anyway, thanks a lot for the help!