Forum Discussion
How to turn one cell red if there is a red cell in another cell - but for an entire column of rows.
Hi there, I am trying to determine how to turn one cell red in a column, if there is another red cell in that same row, but for a series of columns. Here's more context to better explain. I ...
Let's say you want to apply this to A2:A100.
Select this range. A2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select fx (Format cells where a formula is True)
Enter the formula
=OR($I2:$P2="No")
Click + to create a custom format.
Select red as fill color.