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!

Perhaps someone can simplify this for you, but it works. This assumes that
the important journals have the same name day to day.

For condition one:
=NOT(ISNA(VLOOKUP(A1,$H$1:H$4,1,0)))
Where H1:H4 is a list of all the entries you want to appear green. You will
need a longer list for you data. This example assumes the first list item
you want to check is in Cell A1 - change it to the first cell that contains a
"journal" name. Don't foget to choose the appropirate formatting.

For condition 2:
=NOT(ISNA(VLOOKUP(A1,$F$1:$F$3,1,0)))
Same as above, except for F1:F3 represents all the values that should appear
in red. Again, don't forget to set the formatting.

Condition 1 will always take precedence over condition 2, so green would
always win.

--
tj


"TW" wrote:

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!