I have a sheet with a number of links to another worksheet. What i now want
to add is automatic colour change in cells dependant on input from another
formula eg:-

If cell B3 formula answer says E i want all cells below in the same column
to turn a different for example blue. There will be four possible options :-
E L M or O, and the fields needing filling will be from B6 - B31 to P6 - P31

Is there a macro as i have used contitional formating for another field?