excel - Match 2 cell and do a conditional formatting -

excel question: user input value in e3 ex: e3 = 1

// ak11 count values in row b11-aj11 ak11=counta(b11:aj11)-countif(b11:aj11,"*"&"mvr"&"*")

ex: q11="i" , af11="r", makes ak11 = 2

how match cell e3 , cell ak11?

if match, have cell al11 have conditional formatting:

numbers don't match = reddish pattern white font , string "!" numbers match = white pattern white font (basically blank cell)

if did test on seperate cell without ak11's counta formula

am11=1 / an11=1 / ao11 = if(am11=an11,"y","n") | results = y

am11 = 1 / an11 = 2 ao11 = if(am11=an11,"y","n") | results = n

but if run counta formula on an11, results says "n".

for reason doesn't work counta formula beingness in 1 of matching cell.

it's hard understand you're asking exactly, there's much noise in question. if you're asking conditional formatting bit, how it:

just write ! in cell, , give "default format" want, i.e. white font , white background.

then in conditional formatting, utilize formula =$ak11<>$e3 , set reddish background pattern.

here's illustration cells e3 , g3 (ak11 far out right show).

excel formatting if-statement conditional

JC