In a cell I have specified two conditions for formatting:
1. If the cell is in the quot;Decemberquot;-column, I want a border on the left side.
2. If the price entered in the cell is below a certain value I want the
price to be written in red.
It works OK if none or one of the conditions apply, but the red text
disappears in the quot;Decemberquot;-column? Any ideas how to solve this?
I was able to solve it by using three conditions but I assume that there
should be an easier way than this:
1. If december and too low price --gt; red text and border on left side
2. If december --gt; border on left side
3. If too low price --gt; red text.
quot;Bultgrenquot; skrev:
gt; In a cell I have specified two conditions for formatting:
gt; 1. If the cell is in the quot;Decemberquot;-column, I want a border on the left side.
gt; 2. If the price entered in the cell is below a certain value I want the
gt; price to be written in red.
gt;
gt; It works OK if none or one of the conditions apply, but the red text
gt; disappears in the quot;Decemberquot;-column? Any ideas how to solve this?
It sounds to me that you have three conditiojns, so no other way IMO.
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
quot;Bultgrenquot; gt; wrote in message
...
gt; I was able to solve it by using three conditions but I assume that there
gt; should be an easier way than this:
gt; 1. If december and too low price --gt; red text and border on left side
gt; 2. If december --gt; border on left side
gt; 3. If too low price --gt; red text.
gt;
gt; quot;Bultgrenquot; skrev:
gt;
gt; gt; In a cell I have specified two conditions for formatting:
gt; gt; 1. If the cell is in the quot;Decemberquot;-column, I want a border on the left
side.
gt; gt; 2. If the price entered in the cell is below a certain value I want the
gt; gt; price to be written in red.
gt; gt;
gt; gt; It works OK if none or one of the conditions apply, but the red text
gt; gt; disappears in the quot;Decemberquot;-column? Any ideas how to solve this?
留言列表
