Forum Discussion
Conditional Formatting based on another cell value
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!
Use a simple formula instead of conditional formatting:
=IF(COUNTIF(E2:K2, "X"), "Already Done!", "")
Fill down.
4 Replies
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.HansVogelaar this helps, but does not solve the problem of adding text
Use a simple formula instead of conditional formatting:
=IF(COUNTIF(E2:K2, "X"), "Already Done!", "")
Fill down.
