I have a large table of data and I want to be able to distinguish a row of data (by shading the entire row) based on the information in one cell (B -Blue, R -Red and Y -Yellow).
As above one cell will have B, Y or R within and I want to be able to highlight the whole row of data, using conditional formatting, based on this one cell. Can I do this?
As above one cell will have B, Y or R within and I want to be able to highlight the whole row of data, using conditional formatting, based on this one cell. Can I do this?