applying the same formatting to all columns/rows?
I am using a grid view as a calendar (think each column represents a day, the first few columns are names/employee numbers/etc). I have one formatting rule so far: if the value in the cell is "xyz" then color that cell light green.
How can I easily apply that formatting to a) multiple strings (either "xyz" OR "abc") and b) across ALL columns?
Right now the formatting rule says "If 2 Dec is 'SEA' then apply this format to the 2 Dec column."
I seem to be able to only select one column for the <if> condition.
It's a big pain to have to apply the same formatting rule to every column, so I must be doing something wrong.