my bad, I gave the wrong link, I meant
http://www.contextures.com/xlCondFormat01.html
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"santaviga" wrote in message
...
Hi Bob,
Thanks for your reply but I cant see hoew data validation will work as
some
weeks I will have D/S in cell A2 but I only need error to apply when it
arrives after N/S in cell previous and not any other time.
Thanks
"Bob Phillips" wrote:
See http://www.contextures.com/xlDataVal01.html
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"santaviga" wrote in message
...
Hello,
I am looking for a format to place into conditional format or even a
macro
that will alert me on a set occasion. I have data for 4 people on
shifts
over the next 6 months, what I need is a format to turn a cel red if
the
text in it is a D/S for example.
Sunday = N/S
Monday = D/S (I need this cell to turn red as a warning if this
happens)
Cell a1 = N/S
Cella2 = D/S
And so on for the range of 6 months.
Can anyone help me on this problem.
Regards
Mark