I have no idea how to explain this but I am looking to find out how I can run
a rule which will find out if a certain criteria are met in the data range.
Each row has a value that is either in red, blue or black font, I want to
flag these up in col AQ, if the rule is met.

The rule is two in one

so if col A contains red font the rule starts, it must there after NOT FIND
BLUE FONT in any of the following columns B, D, F,
H,I,L,N,Q,R,S,T,U,V,W,AE,AH,AI,AK,AL,AM. It then displays a RED (Y) in col AQ
if no blue font is found.

so if col A contains blue font the rule starts, it must there after NOT FIND
RED FONT in any of the following columns B, D, F,
H,I,L,N,Q,R,S,T,U,V,W,AE,AH,AI,AK,AL,AM. It then displays a BLUE (Y) in col
AQ if no red font is found.

I have to copy & paste the data into col A:AP and therefore the Y or symbol
needs to be in col AQ.
Hope that makes sense & any help is appreciated.