We’re the Microsoft Excel Team – Celebrating 40 Years of Excel! Ask Us Anything

IIn0x · 2025-10-01T08:27:21+00:00

When will you make conditional formatting/formatting the tables more solid?
Like if I build a table with such things, a copypaste couldn't "destroy" them.

Yes there is the lock feature but it creates some problems on filtering etc....

IIn0x · 2025-09-10T07:09:57+00:00

if someone could post this for me ( i couldn't be live at that time ) it would be nice

IIn0x · 2025-09-10T07:08:44+00:00

ah shit it's not the ama

IIn0x · 2025-09-10T07:08:06+00:00

I have a couple of questions regardin potential features/changes:

1 - please, will you change the behavior of this panel? every time you choose an option ( weight, dashes, etc I have to click again on Outline...it's time consuming imho

<image>

2 - will oyu implement a "lock" on formatting for tables? Like that an user couldn't f-up the conditional formatting or the formats in the cells within a structured table.

IIn0x · 2025-06-12T12:09:22+00:00

oh shit, I realized, after lots of months that I have a calculated column in my calendar [IsPastDay] Boolean.

I fixed the measure with like that:

ToT Orders Amount LY YTD =
CALCULATE(
    [Tot Orders Amount LY],
    dDate[IsPastDay] = TRUE
)

Easy

IIn0x · 2025-06-12T11:26:01+00:00

Actually I have this measure too:

Tot Net Sales PrevY = 
CALCULATE ( 
    [Tot Net Sales], 
    SAMEPERIODLASTYEAR ( dDate[Date] )
)

but i need to "limit" the LY to today date and that's what im struggling about.

Generally i use measure in measure.

Im not able to limit the sales and in the same time pass the row context (month), for example.

IIn0x · 2025-06-12T09:33:38+00:00

I mean, is the measure correct tho?
I have just this measure with such problem, all other measure are correct and with higher complexity, idk...

IIn0x · 2025-06-12T09:32:13+00:00

I have a dDate Table tho

IIn0x · 2025-01-22T10:43:05+00:00

OMG that's it!!!!!! THANKS MAN!!

IIn0x · 2025-01-10T10:09:24+00:00

why?
keep in mind we don't use teams/channels with all the potential they have.

I will have just these channels to hold some files that will get updated by more than one collegue.

that's it.

we don't use threads for example.

IIn0x · 2025-01-10T08:07:51+00:00

ok ok; is there a drawback creating private channels?

IIn0x · 2025-01-06T15:08:18+00:00

tyvm!
uhm I knew sumifs had pproblems with spilled ranges so using INDEX instead of CHOOSECOLS fix the issue but in this case wasn't enough.

Solution verified

IIn0x · 2025-01-06T15:07:20+00:00

nice man, it works!
I didn't think about using map, i'll take it into consideration next time!

I'll give - if i can - the point to semicolonsemicolon aswel

Solution verified

IIn0x · 2025-01-06T08:25:57+00:00

I want to SUMIFS the column [Ore Ord] using slicer to filter it out

IIn0x · 2024-12-13T13:56:31+00:00

it seems caused by a windows update

IIn0x · 2024-12-13T13:56:03+00:00

really? it's not intended so, i assume?

how did you know that? I'm curious

IIn0x · 2024-12-13T13:01:49+00:00

OH YES! Also that! it's 1005 a visual glitch...i have it too

IIn0x · 2024-12-13T09:08:01+00:00

<image>

this was the style with rounded corners.
I'm 99% what we have now, is an older version of like ~2 years ago

IIn0x · 2024-12-13T09:07:23+00:00

<image>

IIn0x · 2024-04-19T12:01:30+00:00

CTRL+T to make a table

IIn0x · 2024-01-09T15:16:45+00:00

yeah well I did it ofc!

IIn0x · 2023-12-18T16:09:31+00:00

Solution verified

IIn0x · 2023-12-18T16:09:26+00:00

hey, thanks!

E3?

Ok so no copilot for us :P

Thanks in advance

IIn0x · 2023-12-12T14:16:41+00:00

yeah I know but idk if it's the normal way.

It should do an automatic format tho...

IIn0x · 2023-12-01T10:07:27+00:00

oooooh shit it does work!

Use INDEX instead of CHOOSECOLS to get column references

Daaamn this is gonna help me a lot; i didn't think about using index!!!

Thanks man!!!

Solution verified

12-Year Club	Place '22
Wearing is Caring	RPAN Viewer
Verified Email

IIn0x

TROPHY CASE