Forum Discussion
Highlight a cell until worked
In my case, I am working with columns D&E. Working per row, If I enter information in D, I want E to highlight until I put something into E.
You can do this with Conditional Formatting.
- Select the cells in column E
- Find the Conditional Formatting > Use a formula to determine which cells to format.
- Use this formula: =AND($D2<>"",$E2="")
- Choose a fill color and click OK.