Forum Discussion
Solved
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.
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!!