hello folks welcome back you guys may already know that Microsoft lists
are publicly available now in today's video i will show you
the Microsoft lists formatting features so stay tuned and let's jump into the
video after this short intro
i'm in office 365 landing page from the top
left corner i will click on the ellipses and then i can see the lists application
here if you don't see it here click on all
apps and then scroll down you can see the Lists application here so
you click on it this will take you to the Microsoft lists
landing page here you can create new lists so if i click on new list
button i will create a blank list i will call it project tracker and then
the color i will select this orange color and i will save
it to my list for now click create now the
project tracker list is created so by default there is a title column let me
add few more columns so the first column i
want to add is the choice column status column
so the project status so when you create a choice column you can see the choices
are already color coded so let's say i have first
choice is not started and then second choice is
in progress and the third status choice is completed
so i can change the colors of these choices so for example
for not started i want to change it to this blue color which is fine for in
progress i want to change it to this yellow color
and for the completed one i want to change it to the green color
so once you're done with that click save that's the first formatting
you can do with the list is you can format the color of the
column let me add a new column here this time i want to
show the percentage of the project completed so it will be a number column
so i will just call it percentage completed
click save so now i have three columns titles status and percentage let me
quickly add some data here and then we can do the other formattings
so i will go to click edit mode and add some
data in there so i have created four records here some of them are
not started some in progress and one of them is completed
now you can see that because we have set the status column and we put the
color coded choices here so this formatting is already working so i will
just click on exit quick edit mode now this
percentage complete column is a number column we can format this column as well
so if i click on this drop down and from
the column settings if i click format this column so i'm
interested in in the data bar so when i click on the
data bar you can see the column is formatted
and it's showing the data bar you can edit this by clicking on edit template
so you can set a minimum value maximum value the positive value and if
you have negative value you can display the negative value like that so
i change the color for the positive value if there was any negative
value then you can set the color for the negative value as well so i will just
click on save so this is the second type of column
number column which you can format and show data bars
the third type of column formatting is on the view level so if i click on
all items and format current view you can format
the entire row or you can format one of the column so
if i select entire row i can do the alternate row styling
format so if i click on that you can see the alternate row
have a different color so if i want to change the color i can click
edit row style and here i can change the color
to for example light blue for the alternate row styling
and for the even rows i can maybe want to show something like this
so now you can see that you can set the alternate row
styling color you can also do conditional formatting instead of
alternate row styling so if i click on condition formatting
again this depends on the column which column you want to do it so you can add
rules so for example i would say if status is equal to
not started then i want to show this formatting as this color light blue
color save now you can see that this row is
light blue color now if i go back and i set another rule
i say if the status is equal to in progress then i want to set this
lighter yellow color so you can see the lighter
yellow color is set for the whole row where the status is equal
to in progress and then again i can add another rule
for if the status is equal to complete it
and i want to set it to very light Green color
now you can see the color formatting on the row as well
depending on the status and also the status column
itself is formatted in that color scheme and the number column have these data
bars available so depending on how much percentage is completed
the data bar will show the numbers in the graph format so to just wrap up this
video you guys have learned how you can format
microsoft lists columns and rows using out of the box
features thanks for watching this video consider
subscribing if you're new to the channel by pressing the red subscribe button
below this video give this video a thumbs up if you found
it useful if you have any question related to this video or anything
related to Microsoft lists in general post in the comment section below
i review my comments on the daily basis so i will be happy to answer
thank you