A Global Alias?

[TheRogue]

I thought that some of my other questions were weird...
I have a large, multi-page spreadsheet with lots of tables & formulas (100's)

Many of the formulas look-up data on the various tables & then return the next set of instructions:
IF(A2="RED",[Do This],IF(A2="YELLOW",[Do This],IF(A2="BLUE",[Do This], etc.

There are many of these formulas & going back & changing them individually is going to take forever.
My boss wants it to behave exactly the way that it does, except now he wants the option of inputting "RED/BLUE" & have it return a "TRUE" for either the RED or the BLUE variable (& not just that one combination). Is there anyway for me to tell it globally (maybe VBA?) that "RED/BLUE" is a positive match for either "RED" or "BLUE", so that I don't have to completely re-write hundreds of formulas & test them?

 

[Sam_D_Ben]

Will this work.

Can use "Show Formula" function in the formula tab to see all the formulas in the workheet.

Guess you can edit it, (Ctrl+H)