Hi,
I receive a large spreadsheet that uses cell shading and font colours to indicate if an item is required or expired. It would be a lot easier to review if I had a macro that looked at all the data cells in the worksheet and did the following:
If a cell has no data *and* is shaded, then insert a value of "Reqd"
If a cell has text with a red font, replace the text/value with "Expired"
Unfortunately, I have no idea how to go about creating a macro to do this and any help would be much appreciated.
Thanks
Jim
I receive a large spreadsheet that uses cell shading and font colours to indicate if an item is required or expired. It would be a lot easier to review if I had a macro that looked at all the data cells in the worksheet and did the following:
If a cell has no data *and* is shaded, then insert a value of "Reqd"
If a cell has text with a red font, replace the text/value with "Expired"
Unfortunately, I have no idea how to go about creating a macro to do this and any help would be much appreciated.
Thanks
Jim