Forum Discussion

jw1986's avatar
jw1986
New Member
8 years ago

How to build a matrix like this?

I am trying to build an inventory model for a greenhouse, currently the most efficient method of spcae and inventory modeling we use is an excel matrix shown below which is manually populated and tak...
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi jw1986,

Please try to create a table/matrix, and use the conditional formatting, and check if it meets your requirement, please review more details from here.

Best Regards,
Angelia

jw1986's avatar
jw1986
New Member
8 years ago

Thanks Angela, I reviewed the link you provided and played with the conditional fromatting, it still doesn't quite accomplish what I need it to.  I need each color to represent a different plant genus (product skew) these colored blobs on the matrix then represent a bench location on a time scale....

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi jw1986,

    For your requirement, it's impossible to date, please review the feature request and vote them.

    Best Regards,
    Angelia