Suppose the following table is presented:
A B - ----- 1 | R Red 2 | G Green 3 | B Blue
And one wants to apply different style formatting on the entire row depending on what value the column A of that row holds.
How to do that? Conditional Formatting? Search & Replace? Macro?