software

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
quot;journal aquot; or quot;journal bquot; etc, then color = red and then a separate
condition that if this field is quot;journal cquot; or quot;journal dquot; etc., then color =
green. Also, if a value falls under both quot;red' and quot;green,quot; then quot;greenquot;
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
quot;journalquot; 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.

--
tjquot;TWquot; wrote:

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