1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to "fact check" with conditional formatting?

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?

submitted by /u/Robot-duck
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article