Help!!!!
I am trying to format a table of info. I have 15 values I have placed into another sheet. I have a column of Data (Column D), if any values in Column D equal one of the values on the other sheet I would like to have the cell grayed. I am stuck as it seems I can only compare conditional formatting for one value.
Thanks.
Gary
I am trying to format a table of info. I have 15 values I have placed into another sheet. I have a column of Data (Column D), if any values in Column D equal one of the values on the other sheet I would like to have the cell grayed. I am stuck as it seems I can only compare conditional formatting for one value.
Thanks.
Gary