•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formatting based on a different cell's value
I'm fumbling my way through conditional formatting on a tracking sheet I'm creating. I have the status and required delivery formatting the way I want, but now I'm running into an issue where I want it to clear the formatting of the required delivery cell once the status cell is set to "complete" like the bottom row. The status cells are drop down menu if that makes a difference.
I've tried playing around with "IF" formulas, but nothing seems to be happy with what I'm trying. Any thoughts?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#financial modeling with spreadsheets
#rows.com
#Excel compatibility
#row zero
#Excel alternatives for data analysis
#Excel alternatives
#cloud-based spreadsheet applications
#conditional formatting
#tracking sheet
#status cell
#required delivery
#clear formatting
#dropdown menu
#IF formulas
#complete
#formatting issue
#data validation
#cell value
#Excel
#automated updates