Forum Discussion
Herman Pieters
Jan 22, 2018Copper Contributor
Conditional Formatting
I want to color fill "F 11" in red based on column "E 11" which is empty.
Willy Lau
Jan 23, 2018Iron Contributor
You may have already found the solution. If not, you may try
- select F11 cell
- click Home tab in Ribbon
- click Conditional Formatting, select New Rule.
- click Use a formula to determine which cells to format.
- in the textbox of Edit the Rule Description, type
=E11=""
- click Format button to apply the format that you want
- click OK button in Format Cells dialog. Click OK button in New Formatting Rule dialog.
- done.