•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to "fact check" with conditional formatting?
Our take
To ensure every column in your schedule contains at least one instance of specific text, like "A," "B," "C," or "D," you can use a combination of a formula and conditional formatting in Excel. Start by creating a formula that checks for the presence of these values within each column. Once established, apply conditional formatting to visually highlight any columns that do not meet this criteria. This approach will empower you to confirm that all shifts are adequately covered, enhancing your scheduling efficiency.
I'm sure it is a simple formula I'm missing, but I'd like to basically "fact check" in excel, using a formula and from there conditional formatting. Basically I have a type of schedule, and I want to make sure each column has at least 1 of certain text in it (to make sure all shifts are covered). So basically as long as Column A contains at least one instance of "A,B,C,D" etc, it is "True", and if not, false.
Is there a way to do this?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#AI formula generation techniques#Excel compatibility#Excel alternatives for data analysis#formula generator#Excel alternatives#rows.com#financial modeling with spreadsheets#fact check#conditional formatting#Excel#formula#schedule#column A#shifts#text#instance#True#false#certain text#data validation