software

Hopefully someone can help, I posted the question below yesterday and got
the correct answer for my question, however I didnt include all the
information required. The additional information is
cell A2lt;A1 and cell A3 equals A2, then make cell red else make cell white.
This is now all the conditions. any help would be very much appreciated.

Thanks in advance BigH
In conditional formatting:
condition 1 - quot;formula isquot; =AND(A1=A2,A3lt;=A1)...click on Format and format
as desired, click on Add.
condition 2 - quot;formula isquot; =AND(A1=A2,A3gt;A1)....again format as desired.

HTH
JGquot;BigHquot; wrote:

gt; Hi there hopefully someone can help,
gt;
gt; I want the cell to turn white if its the same date as two other cells or
gt; if
gt; its less than the date in these two other cells, else it goes red if
gt; greater
gt; than the dates in the two cells.
gt;
gt; i.e cell a1 and a2 must have the same dates. cell a3 if it has the same
gt; date
gt; or less than a1 and a2 it goes white, if its greater than a1 and a2 (whose
gt; dates must be the same) then it goes red
gt;
gt;
gt; thanks in advance BigH

use another formula of

=AND(A2lt;A1,A3=A2)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;BigHquot; gt; wrote in message
...
gt; Hopefully someone can help, I posted the question below yesterday and got
gt; the correct answer for my question, however I didnt include all the
gt; information required. The additional information is
gt; cell A2lt;A1 and cell A3 equals A2, then make cell red else make cell white.
gt; This is now all the conditions. any help would be very much appreciated.
gt;
gt; Thanks in advance BigH
gt;
gt;
gt;
gt; In conditional formatting:
gt; condition 1 - quot;formula isquot; =AND(A1=A2,A3lt;=A1)...click on Format and format
gt; as desired, click on Add.
gt; condition 2 - quot;formula isquot; =AND(A1=A2,A3gt;A1)....again format as desired.
gt;
gt; HTH
gt; JG
gt;
gt;
gt; quot;BigHquot; wrote:
gt;
gt; gt; Hi there hopefully someone can help,
gt; gt;
gt; gt; I want the cell to turn white if its the same date as two other cells or
gt; gt; if
gt; gt; its less than the date in these two other cells, else it goes red if
gt; gt; greater
gt; gt; than the dates in the two cells.
gt; gt;
gt; gt; i.e cell a1 and a2 must have the same dates. cell a3 if it has the same
gt; gt; date
gt; gt; or less than a1 and a2 it goes white, if its greater than a1 and a2
(whose
gt; gt; dates must be the same) then it goes red
gt; gt;
gt; gt;
gt; gt; thanks in advance BigH
gt;
gt;
gt;