Forum Discussion

Linda A. Barnes's avatar
Linda A. Barnes
Copper Contributor
Sep 29, 2019

excel help with formula or something

https://1drv.ms/x/s!ApqQZFKwCI2m0w3cx09plC0U9S7H?e=Q5WpPy I have a key code in the document I can't remember all the colours but need to lighten all the colours and I would like colours across the row, so when I open I can see which document are check to be print sold and relist currently list or demage and not for sale.   I was told I need to post here because support help could not help.

19 Replies

      • IngeborgHawighorst's avatar
        IngeborgHawighorst
        MVP

        Hello Linda A. Barnes ,

         

        the document that you shared in you question seems to be your original file with all your company data and links. I urge you to edit your question and remove that link. Then create a small sample file with just a few rows of dummy data and upload that here with the paper clip icon that shows below the reply box. 

         

        Explain the logic of what you want to achieve, e.g. "if cell A1 has the word "rhabarber" the whole row should turn orange" -- along these lines.