Same text in same column but different cell is high lighted in red

[ipbr21054]

Evening,

As per the title.
The issue is column Q
Example
Cell Q10 shows Dog
Cell Q156 also shows Dog if i change the text to Cat then the Red high light is gone

Now these two cells are high lighted Red ?

I do have a code on this form which looks for duplicated entries in Column A for customers names but this issue is in column Q

Not sure why this is happening but will look out the code if it helps & reply back here,Having said that the cells in column Q which are Red do not show Red in column A

 

[Fluff]

Do you have any conditional formatting on col Q?

 

[ipbr21054]

Hi,
Would this be the correct way to check.

Ive deleted all entries in the cells for column Q
Then select Conditional formatting,Manage rules.

I now see some rules high lighted Red.
These are for the following,
=$Q$11
=$Q$11
=$Q$46
=$Q$7
=$Q$6
=$A$1,$A$4:$A$1048576
=$Q$10:$Q$178

I dont remember adding these ?
Is it safe to delete the ones assigned for Q ?

How do i know if they are just active for this sheet / workbook ?

Thanks,this looks like this issue here.
I will await instructions thanks.

 

[Fluff]

Is it safe to delete the ones assigned for Q ?

Absolutely no idea, as I don't know what they are designed to do.

How do i know if they are just active for this sheet / workbook ?

CF only works on the sheet they are in.

 

[ipbr21054]

So anything that has a Q in the code needs to go otherwise its going to be Red.
Thanks

 

[ipbr21054]

Hi,
just an update.
Ive delete the CF for anything in column Q and all seems fine.

Thanks