I would like to conditionally format a range of cells so that if the value contained in a cell within the range appears in a cell in another defined range prefixed by the letter E the cell containing the value will be conditional formatted.
eg cell A1 = 4
cell B1 = E4
then cell A1 conditionally formatted.
thanks for looking
brain dead today
Nick
eg cell A1 = 4
cell B1 = E4
then cell A1 conditionally formatted.
thanks for looking
brain dead today
Nick