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.
Use conditional formatting on column E.
- Select the range to check, for example E2:E1000.
- Go to Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format.
- Enter this formula:
=AND($D2<>"",$E2="")
4.Choose a fill color and select OK.
The $D2 reference checks whether column D has a value on that row, while $E2 checks whether column E is still blank. As soon as a value is entered in E, the highlight disappears.
If the data starts on a different row, replace 2 with the first row of the selected range.