Hi
Does anyone know how to make a whole row red if a certain word appears in a cell?
Please find below a simple example:
The data below covers cells A1:C3 and every cell in that range has a "-" with the exception of cell C2, which has the word "FALSE."
I'd like to make the whole row red (from column A to column C) IF the word "FALSE" appears in a cell in that range.
I've tried to highlight the whole range, then gone to Conditional formatting and selected "use a formula to determine which cells to format" but I'm not sure what formula should be used in this instance.
Thanks in advance.
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Does anyone know how to make a whole row red if a certain word appears in a cell?
Please find below a simple example:
The data below covers cells A1:C3 and every cell in that range has a "-" with the exception of cell C2, which has the word "FALSE."
I'd like to make the whole row red (from column A to column C) IF the word "FALSE" appears in a cell in that range.
I've tried to highlight the whole range, then gone to Conditional formatting and selected "use a formula to determine which cells to format" but I'm not sure what formula should be used in this instance.
Thanks in advance.
- | - | - |
- | - | FALSE |
- | - | - |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>