Forum Discussion
Solved
Conditionally Format Cell Based on the Text of Another Cell AND if it's Blank
Hello,
Column W cells include "Yes" or "No" options.
If any cell in column W includes "Yes" then I would like excel to check if column X includes text. If any cell in column X does not include text (not specific text) then I would like the cell in column X to be filled red.
If any cell in column X does include text then no formatting needed.
Thank you
Let's say you want to apply this to X2:X10.
Select this range. X2 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=AND(W2="Yes", X2="")
Click Format...
Activate the Fill tab.
Select red as highlight color.
Click OK, then click OK again.
Let's say you want to apply this to X2:X10.
Select this range. X2 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=AND(W2="Yes", X2="")
Click Format...
Activate the Fill tab.
Select red as highlight color.
Click OK, then click OK again.That worked! Thank you!
