I have a follow up question to one already places.
I am looking to "replace" the conditional formats with "static" or normal formats based on the condition format results.
In my example column AE dictates if the line is a header or a data line.
If Header, i want to leave to conditional formats alone.
If data i want to "replace" the conditional formats with the resulting formatting and remove the value in the cell.
This is to be applies to only colums F thru W leaving all other conditional formats in tact. The resulting document will be an "order form" which gives the customer indication of stock level without giving them the actual values.
I cannot figure this out from the previous solutions of converting Conditional Formats to "normal"