Formula or Macro for CF

[santaviga]

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

 

[Bob Phillips]

See http://www.contextures.com/xlDataVal01.html


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[FSt1]

hi
see your other post

Regard
FSt1

 

[santaviga]

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

 

[santaviga]

Hi, I have looked at my other post but not a working situation, I also posted
here as to open the question up to a possible macro.

Many thanks

 

[Rick Rothstein \(MVP - VB\)]

You left the N/S requirement out of your original posting. Select the cells
from A2 (not A1) down to the end of expected data and use this Conditional
Formatting formula (Formula Is in drop down)...

=AND(A2="D/S",A1="N/S")

Rick

 

[santaviga]

Excellant many thanks, how can I put in this data qickly over 6 months?

many thanks

 

[Rick Rothstein \(MVP - VB\)]

I'm not sure I understand your question. If you are asking how to apply the
formula over your 6 months, simply click in A2 and drag down until all 6
months are selected (although you can select more than you need if you think
you will have to provide this functionality for more than 6 months); then
click Format/Conditional Formatting from the menu bar; select "Formula Is"
from the first drop down and paste the formula into the 2nd field; click the
Format button and select the formatting you want; then OK your way back to
the worksheet. That's it... everything will be automatic after that.

Rick

 

[santaviga]

Many thanks for your help Rick

Much appreciated.

Mark

 

[Bob Phillips]

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)