Formating Excel Sheet

To format a list of values in a column if they are not present in the list of values mentioned into another sheet column,


Select the range of cells you want to apply formatting to
Click on the Conditional Formatting
Click on the new rule

Specify formula
=countif(sheet1!b2$:c3$,d2)
select format and click apply

d2 is the first record of the selection where we are applying the formatting to.

=countif(dictionarylist,d2)
dictionarylist is the name of the cells values from where we like the values to compare to. to create a named list, select list of values, and on the left of formula where it show column name change it to some list name e.g. dicitionarylist

if you want to format a cell where values does not exits in the list than

= countif(dictionarylist,d2)=0

=if(isblank(m9),false,COUNTIF(lifecyclelist,M9)=0)

http://www.contextures.com/xlCondFormat03.html
http://www.contextures.com/xlCondFormat01.html