Feb 06 2024 12:54 PM
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!
Feb 06 2024 01:44 PM
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.
Feb 06 2024 02:18 PM
@Hans Vogelaar this helps, but does not solve the problem of adding text
Feb 06 2024 03:17 PM
SolutionUse a simple formula instead of conditional formatting:
=IF(COUNTIF(E2:K2, "X"), "Already Done!", "")
Fill down.
Feb 07 2024 09:33 AM
Feb 06 2024 03:17 PM
SolutionUse a simple formula instead of conditional formatting:
=IF(COUNTIF(E2:K2, "X"), "Already Done!", "")
Fill down.