Conditional Formatting based on another cell value

[Mspooner87]

Hello! I'm working on a spreadsheet for work and would like to format a column to say "Already Done" if the value in a Cell on that line has an X or something similar. Help!

[#2]

@Mspooner87 

Let's say you want to format B2:B50 if E2:E5 contains an X.

Select B2:B50.

B2 should be the active cell in the selection,

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula

=$E2="X"

(Remember, E is the column you want to look at and 2 is the row number of the active cell in the selection)

Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.

[#3]

@Hans Vogelaar  this helps, but does not solve the problem of adding text

[#4 · Accepted solution]

@Mspooner87 

Use a simple formula instead of conditional formatting:

=IF(COUNTIF(E2:K2, "X"), "Already Done!", "")

Fill down.

[#5]

Thank you!! That did it!!