My work group shares a simple spreadsheet to track the work (journals) we get
in daily. There are certain journals (100 total) that have priority and need
the font to be formatted red. There are other journals (20 or so) that also
have priority and need the font to be formatted green. All new work is
entered in Column B. How do I set conditional formatting for if this field is
"journal a" or "journal b" etc, then color = red and then a separate
condition that if this field is "journal c" or "journal d" etc., then color =
green. Also, if a value falls under both "red' and "green," then "green"
should take priority, and the text should be formatted green. I have a little
programming experience, but it's been at least 5 years or more. Thanks!