Max
thanks for the response but the problem is that the date in b2 is not fixed
it is generated by the following formula

=AND(B2<"",B2<TODAY()+183)

or in some caes by

=TODAY()39857

As you probably figured out I am new at this and maybe it is not possible to
change the color this way

Thanks




"Max" wrote:

Try something like this as the CF's "Formula Is" for E2:
=AND(B2= --"19 Oct 2008",ISTEXT(F2))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
"SRN" wrote:
I am trying to format a cell to change two two different colors when values
in two other cells meet some conditions. For example

The cell being formatted is E2 (This cell will have no text just a color
pattern)
I want it to change to Yellow when a particular date is reached in B2 (This
I have figured out)
I want the cell to change to green when the first condition is met AND there
is any alphanumeric data in F2

Any ideas or suggestions. Any help would be appreciated

Thanks