•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Attempts at conditional formatting
Hi all- I'm attempting to create a sheet to show when submissions are late and when they are on time. I figured out how to conditionally format the "status" columns so they show green and red based on the value within them, but I'm running into an issue that when there has NOT been a value (date) assigned, it subtracts the date from nothing as opposed to..... doing nothing. I'm sure this is a simple answer for you guys, but I'm new, so please be kind.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#cloud-based spreadsheet applications
#real-time data collaboration
#conditional formatting
#submissions
#status columns
#late submissions
#on time
#Excel
#date assigned
#value
#sheet
#red
#green
#new
#Dizzy-Cabinet-7093