Pivot Table Conditional Formatting

Pivot Table Conditional Formatting

Computer Tutoring

3 года назад

43,563 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Anill Patel
Anill Patel - 23.09.2023 22:18

Excellent video presentation.
Very useful tips and so well explained.
Thanks for sharing Simon.

Ответить
Vipin Manral
Vipin Manral - 01.07.2023 11:48

you are best.

Ответить
Balraj Virdee
Balraj Virdee - 30.06.2023 23:11

Thanks so much mate, very well explained 👍🏽

Ответить
Rich Ard
Rich Ard - 17.02.2023 22:54

You Rock Simon! Cheers!

Ответить
Lucas Mota
Lucas Mota - 16.12.2022 20:05

Good video, but my excel doesn’t show that little square with thise 3 options

Ответить
Robert Strickland
Robert Strickland - 09.12.2022 14:38

I have watched a lot of Excel videos. A great combination of how and why of doing things

Ответить
Korntipa Pipattanarungka
Korntipa Pipattanarungka - 24.11.2022 16:17

Thank you so much , i can do it , so great🥰👍👍👍

Ответить
glassfwhiskey
glassfwhiskey - 18.08.2022 04:01

This video was exactly what I was looking for, I thought it would be difficult to apply this, but it was so straight forward.

Thank you for making this video.

Ответить
Pipo
Pipo - 23.03.2022 20:18

Great tutorial video. Have been looking for this answer for a while and finally here you bring it on a silver plate.. One question though, there is no way around to include the first row label? I get a message saying that I cannot apply CF to a range that has cells outside the Pivot Table data region.... Any comments please?

Ответить
Mark Goodger
Mark Goodger - 03.03.2022 12:54

Thank you, that's been bugging me for years.

Ответить
Odaya
Odaya - 26.02.2022 13:12

Thanks! It helped me with applying conditional formatting for all cells in the pivot table

Ответить
Joe McMeekin
Joe McMeekin - 21.01.2022 15:01

You have no idea how much this has helped! Thank you for sharing!

Ответить
Murtaza Sohail
Murtaza Sohail - 19.01.2022 21:46

Dear Simon , great video ... just helped me out of a problem in which i was stuck for almost an hour ... salute ..

Ответить
argelinC
argelinC - 14.01.2022 19:09

Just worked through this series on Excel and accounts and found them very useful. Lots of things I learned from your clear explanations and I have much more confidence with pivot tables now. Many thanks.

Ответить
Juan Gomez
Juan Gomez - 24.11.2021 03:55

Simon this is a great video, I've been watching and learning a lot of new skills thanks to you. I have a question which I have never seen explained anywhere ... are we able to highlight the Rows section in a pivot table based on the results from one or several of the columns in the Values section of the pivot? It would be similar to highlighting the Month on the row labels of your example on this video. Thank you for your help!!!

Ответить
Naseeh Mk
Naseeh Mk - 12.09.2021 16:05

Good🥰

Ответить
Shireen Adams
Shireen Adams - 11.09.2021 10:54

Simon I love your tutorials

Ответить
Mukulverse
Mukulverse - 19.08.2021 23:27

Fantastic 🔥

Ответить
SmartyArjun
SmartyArjun - 23.06.2021 10:34

Can you color the 1st column based on formula !

Ответить
Cindy Cubbin
Cindy Cubbin - 21.04.2021 11:33

I like the flexibility to change the target and the formatting automatically updates! Cool.

Ответить
XL Training
XL Training - 21.04.2021 11:10

Cool like the litte hack so you can format the whole, well nearly, row in the Pivot Table

Ответить