•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formatting based on checkboxes in 2 other cells
I currently have conditional formatting programmed in column C based on if Column G and H are blank or not in 3 scenarios. The sheet is setup as a table. I'm trying to apply the formatting to the whole table.
Highlight red if both blank: =AND(ISBLANK(G4), ISBLANK(H4))
Highlight yellow if one blank: =OR(ISBLANK(G4), ISBLANK(H4))
Highlight green if neither blank: =AND(NOT(ISBLANK(G4)), NOT(ISBLANK(H4)))
I would like to put checkboxes in those cells instead of blank vs "ok". But putting checkboxes makes everything green since they aren't blank.
I tried different variations of =AND(=G4=FALSE, =H4=FALSE) for red, but it gave an error and I couldn't save it.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#cloud-based spreadsheet applications
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#conditional formatting
#checkboxes
#blank
#ISBLANK
#table
#highlight red
#highlight yellow
#highlight green
#G4
#H4
#AND
#OR
#NOT
#blank vs 'ok'