What am I doing wrong ( Conditional Formatting )

[Please_H]

Hi,

Good Day to All of you

I am using 4 conditions to the same set of data which the range of is D62:D1550

Condition 1 : Cell Value > Less than > 01/10/2018
Condition 2 : Format only Cells with > Blanks
Condition 3 : Format values where this formula is TRUE > =istext(D62:D1550)

Until this everything went fine,

Then I entered,

Condition 4 : Cell Value > greater than > 31/09/2019

Now after I have entered Condition 4,
Condition 3 doesn't seem to be active.

What did I do wrong? Reason for me to add condition 3 was some users can enter date under invalid format or date with texts or other info mistakenly and it is essential we identify them separate.

Thank you in Advance.
Please help

 

[Fluff]

Make sure that your rule 3 is before your rule 4

 

[KolGuyXcel]

change the range D62:D1550 to a single cell like
=istext(D62)


BTW, 31/09/2019 isn't a valid date!

 

[Please_H]

@Fluff

I didn't understand what you meant there Sir

I just typed the sequence of how I entered the formatting....


@KolGuyXcel

that didn't work Sir

 

[Please_H]

BTW, 31/09/2019 isn't a valid date!

changed it to 01/12/2019 and the result is the same

 

[Fluff]

@Fluff

I didn't understand what you meant there Sir

If you select manage rules, make sure that the "IsText" rule is above your "Greater Than" rule

 

[Please_H]

Make sure that your rule 3 is before your rule 4

KAPEEESH

Ok Sir, I understood what you meant,

I had to use the arrow keys to get them in order...

Found out something went wrong when I tried to edit a Rule when Mr. KolGuyXcel advised me...

Then I realized the order has some what changed.

Thanks a lot Sir...

Condition 1 : for Blanks
Condition 2 : for anything other than Dates
Condition 3 : less than Date
Condition 4 : more than Date

WORKED.

 

[Fluff]

Glad it's working & thanks for the feedback

 

[Please_H]

@ KolGuyXcel

Thanks alot Sir for stopping by to give me a hand...

 

[Please_H]

Glad it's working & thanks for the feedback

Thanks a lot again &

Have a great Day Sir...