Hello,

I'm currently programming a macro for excel and I esssentially want to get
the macro to look at a range and if this range has a certain value ("y" for
yes) then change the format in another cell. I know this can be done for the
same range using conditional formatting but I want to format a call based on
a seperate cell.

Thanks