conditional formatting check in vba

[mahex]

hello everyone,

i have a column that conditional formatting ( highlight duplicate value) is applied to it. some of cells are getting highlighted and i want to use if statement like below:

if cells(i,j).value= vbRed then
command
end if
but because the actual formatting is normal it doesn't trigger the if statement

is there anyway that i can find that a cells is highlighted or not?

any comment is appreciated

 

[Joe4]

See: http://www.cpearson.com/Excel/CFColors.htm