Forum

Notifications
Clear all

Color or Shade Columns

6 Posts
3 Users
0 Reactions
97 Views
(@mymalone)
Posts: 103
Estimable Member
Topic starter
 

I can't figure out how to do this other than manually.  Can you help me figure it out?

When there are three items listed in column P, I would like to have them entered in Columns AF:AK.  When Column P has more than three items, I would like Columns AF:AK shaded in a color (light gray is okay).

When there are four items in Column P, I would like to have them entered in Columns AM:AV.  When Column P does not equal to four items, I would like Columns AF: AK shaded in a color (light gray is okay)

 
Posted : 28/03/2019 12:28 pm
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
 

Please supply a workbook with sample data and examples of your expected outcomes, and cover all scenarios.

Thanks

Phil

 
Posted : 28/03/2019 11:20 pm
(@mymalone)
Posts: 103
Estimable Member
Topic starter
 

The request has changed somewhat.  I would like for the data in Column U to pair up with the data in Column V.  Where there are three items listed in Column U, I would like to have them entered in Columns AF:AK.  When there are four items listed in Column U, I would like to have them entered in Columns AF:AO.  Expected results are listed in the spreadsheet.

 
Posted : 29/03/2019 10:13 am
(@mymalone)
Posts: 103
Estimable Member
Topic starter
 

I added the attachment, wasn't sure if it was received previously.  It might be a little different, but the concept / expectation is still the same.

 

Thanks

 
Posted : 31/03/2019 12:08 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Melinda

You already have the fixed formulas in all the columns.

Now you only need to check the length of the cell in column U to determine which of the formulas to use in each column.

I suggest you remove the comma in columns U and V as they are not necessary and in certain case make your formulas a bit longer

e.g. MID($U16,1,1)&MID($U16,1,3) could have been written as MID($U16,1,2) when the comma in U16 is removed.

Not sure about your cell color but conditional formatting (by checking on the length of column U) should do the trick.

I think in future you should redefine your needs again if you post a new file as it is very confusing for us to try to "map" the new file against your "old" requirements as the columns are different.

Sunny

 
Posted : 01/04/2019 11:00 pm
(@mymalone)
Posts: 103
Estimable Member
Topic starter
 

Perfect!!  Thank you

 
Posted : 02/04/2019 6:16 am
Share: