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.
2 Replies
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.
Here, sduesler, is a spreadsheet that does what you're asking on the basis of one assumption: that assumption is that what you're entering into column D is text in nature. I use the conditional formatting function, with the rule being, in effect, paint a light red background in E if E is blank and D contains text.
if it's numeric data that you're entering in column D, then you'd change the ISTEXT to ISNUMBER.
If what you might enter into D could be either number or text, then we'd have to come up with a more extensive rule, but for now I'm going to assume that text or number is the case.
