•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
Our take
Are you struggling to apply conditional formatting in your spreadsheet when using checkboxes? Transitioning from blank cells to checkboxes can transform how your data is visually represented, but it comes with its own set of challenges. To highlight rows based on the status of checkboxes in columns G and H, you need precise formulas to avoid defaulting to green, which occurs when checkboxes are checked. Discover how to effectively implement these formulas for accurate color coding, ensuring your table communicates the intended status clearly.
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Conditional formatting with checkboxes and datesI need to highlight a cell (Column "I") that has a checkbox if it is unchecked and a date in a separate column (Column "D") occurs in the next 3 days. https://preview.redd.it/vrpvkbcaxwzg1.png?width=464&format=png&auto=webp&s=40bcf88095d42cc9a11c8edd7ae76375e7a703ed Thank you submitted by /u/_Rocksol [link] [comments]
- How to make conditional formatting exclude blank cellsMaking a working hours chart but I'm not very well versed in many Excel functions so I've been consulting google results for most, but I don't understand why conditional formatting is marking blank cells green for value >0. The detailed issue is as follows: I have columns for for date (C), start time (D), end time (E), and the following (using row 5 for example): Total time F5 =IF(D5;E5-D5;"") Number format: Time Overtime: G5 =IF(OR(F40="";TIME(8;;)="");"";(F40-TIME(8;;))*24) Number format: General I have set up conditional formatting in column G to color everything that is below 0 red, everything above 0 green, but all the blank cells with above formula applied are colored green too. Cells that equal 0 are left without color, as I intended. My hope is that blank cells also remain white until they recieve a value. Is there a way to achieve that? I appreciate all the help! submitted by /u/ace_098 [link] [comments]
- Conditional formatting highlighted cellsHoping you can help me! Everyone at my office is a huge novice with Excel - I understand the basics but am not terribly great myself. We need one (hopefully) simple thing. Essentially, we have a dataset that we want to flag column A with a highlighted color if anything in that row is a color. Column A will always contain one of 5 words -- I've already done that with data validation. But what we want is, for instance, if I highlight cell H7 in yellow, it would then highlight A7 with the same color. I tried playing around with conditional formatting but I wasn't able to get it quite right. Thanks in advance for any assistance you can give! submitted by /u/THE_GREAT_PICKLE [link] [comments]
- Conditional Formatting not highlighting selected cells when keyword is typed into a cell range unless it’s the first cell of the rangeHello everyone! I’m working on a project for work and I’m running into an issue that I can’t solve. I work for housekeeping at a large property and we will, from time to time, shuffle around housekeepers and move their areas. I’m trying to use conditional formatting to highlight cells that resemble the different areas the housekeepers can be assigned as green once someone assigns that section to a housekeeper so they know the area is covered. So far, I’ve tried using =[Range of Cells that has a Data Validation drop list of different sections]={Name of Section from Data Validation Table} with the “Apply To” range being 4 cells several columns over from the Section Selection range. The group of cells will only highlight when the Section name is in the first cell of the range but no others. Any help would be greatly appreciated! submitted by /u/WhereTheresAMills [link] [comments]
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'