I have a column of blank cells. If I type something into a cell, I want the cell immediately below that one to turn red. Any ideas for conditional formatting help?
Google-sheets – Google Sheets conditional formatting based on cell above it
google sheets
Related Topic
- Google Sheets – How to Use IF, AND Conditional Formatting
- Google Sheets – How to Lock or Protect Conditional Formatting
- Google-sheets – Conditional formatting based on another Sheet
- Google-sheets – Google Sheets Conditional Formatting For Dates and a Blank Row
- Google-sheets – Google Sheets Conditional Formatting Isn’t Working
- Google-sheets – Google Sheets Conditional Formatting for expiration dates
- Google Sheets – Apply Conditional Formatting to a Blank Cell Based on Another Cell
- Google-sheets – column conditional formatting based on its sum
Best Answer
Try this custom formula:
=not(isblank(offset(A1,-1,0)))The only problem that I can see is that A1 is automatically highlighted, regardless of any value in any other cell