Conditional formatting

[Kelly]

If a date appears in column K and not in column L how do I turn the cell in
column M red showing an X?

[CLR]

IN M1 type this formula.......

=IF(AND(LEN(K1)=5,LEN(L1)<>5),"X","")

Then, select M1, and do Format > ConditonalFormatting and set Cell Value Is,
Equal To, X.....then do the format button and select PatternTab > select
the red square > OK > OK

Vaya con Dios,
Chuck, CABGx3



"Kelly" wrote:

> If a date appears in column K and not in column L how do I turn the cell in
> column M red showing an X?

[Kelly]

Sorry. I gave the wrong information. What i am trying to accomplish is if
Column A has a letter value in it and there is no date value in column b,
then i want column c to have the letter "x" put in it and the cell background
color formatted to red. Additionally, if there is a letter value in Column A
and a date value in Column B, then Column C should remain blank.

"CLR" wrote:

> IN M1 type this formula.......
>
> =IF(AND(LEN(K1)=5,LEN(L1)<>5),"X","")
>
> Then, select M1, and do Format > ConditonalFormatting and set Cell Value Is,
> Equal To, X.....then do the format button and select PatternTab > select
> the red square > OK > OK
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Kelly" wrote:
>
> > If a date appears in column K and not in column L how do I turn the cell in
> > column M red showing an X?

[CLR]

Change the formula to the following and put it in C1 instead of
M1......Conditional Formatting instructions will stay the same but be
performed on C1 instead of M1.

=IF(AND(ISTEXT(A1),LEN(A1)=1,LEN(B1)<>5),"X","")

hth
Vaya con Dios,
Chuck, CABGx3



"Kelly" wrote:

> Sorry. I gave the wrong information. What i am trying to accomplish is if
> Column A has a letter value in it and there is no date value in column b,
> then i want column c to have the letter "x" put in it and the cell background
> color formatted to red. Additionally, if there is a letter value in Column A
> and a date value in Column B, then Column C should remain blank.
>
> "CLR" wrote:
>
> > IN M1 type this formula.......
> >
> > =IF(AND(LEN(K1)=5,LEN(L1)<>5),"X","")
> >
> > Then, select M1, and do Format > ConditonalFormatting and set Cell Value Is,
> > Equal To, X.....then do the format button and select PatternTab > select
> > the red square > OK > OK
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> > "Kelly" wrote:
> >
> > > If a date appears in column K and not in column L how do I turn the cell in
> > > column M red showing an X?

[CLR]

Didn't we just do this under your other post "Conditional Formatting"?

Vaya con Dios,
Chuck, CABGx3



"Kelly" wrote:

> If a date appears in column K and not in column L how do I turn the cell in
> column M red showing an X?