Forum Discussion
Conditional Formatting based on another cell value
Use a simple formula instead of conditional formatting:
=IF(COUNTIF(E2:K2, "X"), "Already Done!", "")
Fill down.
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.
- Thank you!! That did it!!