•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formatting entire row based on value in column
I feel stupid putting this out there, but it's not my first "duh" question and it won't be my last.
I am currently attempting to higlight the entire row of columns A:M (62 rows) based on the column of days overdue in G.
Ideally, this would be:
If value in G is between 1-15, format light green
If value in G is between 16-30, format yellow
If value in G is 31+, format red.
My current super lame attempt only applies the conditional formatting to B:G, AND it's including 0s. I'm absolutely losing my mind over this simple thing. Any help would be greatly appreciated!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#row zero
#cloud-based spreadsheet applications
#Excel compatibility
#Excel alternatives for data analysis
#conditional formatting
#highlight
#days overdue
#rows
#columns
#value
#format
#light green
#yellow
#red
#g column
#cells
#attempt
#1-15
#16-30