# Highlight Cell If Same Value Exists In Another Column

Oct 2, 2007I'm trying to do a formula without using a marco. The formula would do the following:

- Highlight value in column A if the value is found in column B and on the same line value in column F and I are equal to zero;

- Value in column A could match many value in column B

I tried everything I know but can't seems to make it work.