• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cell Coloring without VBA Code or Conditional Formatting


New Member
There are alphanumeric values with four different cell coloring in column A1 to D1, instead of simply Copy-Paste or Conditional Formatting or VBA Technic, I want to copy those cells with values and colors in different columns with simple IF-ELSE function which is pure excel category. I already solved this through VBA and Conditional Formatting, but how can I do this with IF-ELSE function?