You have not attached any data, only as screenshot. For us to help you it's generally better to provide the data (even better is a Tableau packaged workbook with some sample data and your work so far).
Please know that in general Tableau treats data like a database does where primarily aggregation is done over columns, whereas Excel with it's cell-based model doesn't really care whether a calculation is across columns or rows. In this case the data is in a "wide" format where the goal is to treat multiple columns as if they were a single Color attribute, and this is where it's helpful for Tableau to have that data as a single column.
You have three-ish options:
1) Leave the data as is and create a calculation for each color, it would be of the form:
IF [Color 1] = 'Blue' OR [Color 2] = 'Blue' OR [Color 3] = 'Blue' THEN 1 ELSE 0 END
And then aggregate that with the default SUM() aggregation. The challenge with this method is that you need a calculation for each color and any new color(s) will require additional calculations.
2) Pivot the data and adjust your other calculations to deal with the "tall" data set, for example by using COUNTD() instead of COUNT(), and/or using Level of Detail expressions to adjust for replicated values.
3) Alternatively you can have multiple Tableau data sources pointing at the original data. One would be an untransformed data set for some measures, and then a pivoted data set for the color calculation. Then worksheets can be built on each data source as needed and be combined into a dashboard if need be. If you want to show both the unpivoted & pivoted data in the same Tableau worksheet it can be possible to do this via a Tableau data blend however the extra complexity & performance implications could make suggestion #2 easier.
Thanks I’ll look at option 2