OK so time to learn another very important feature of Excel.
The you can format your data based on vertical conditions.
So for example if I choose this column of retail price and I only want Excel to highlight me where prices
are relatively very higher I'll just click on this column to select the column I will go to column and
click on this conditional formatting I will choose to get about this time.
These are about to show me that if these prices are higher or lower so this is a very beautiful way
of adding this beautiful bar charts in bars along the lines.
But that is not the only way you can add your conditional formatting you can do some other things as
well.
So for example if I if legacy if I want to highlight some products very you know the votes are duplicates
I will just click this column here and I was go to form a conditional formatting.
I will say highlight cell rules.
Now said duplicate values set so that only highlight the values where the records are duplicates.
So if there are no duplicates that serve as non does not highlight anything here.
So you just select okay and I'll say that is fine and you will see that extra has not highlighted anything
because there's no road that is top to get through.
But just to show you I will do one quick thing I'll just copy and paste this duplicate up here and you
will see that Excel has now also highlighted that because the birth name is duplicate.
So I just can't do it for now.
Similarly you can do conditional formatting based on some other parameters as well.
So let me go to Porter Goss and let me say that conditional formatting and now the highlight to the
highlights so uh that the the condition that I'm giving is only highlighted the cells if the answer
is greater than let's say I'm saying on set is greater than one and click Okay so you will see that
excellent only highlight the columns where my answer is greater than one.
All others have not been highlighted yet.
Let us learn some other features of conditional formatting suitable to this particular column and I
say include and highlight.
Let's say you can.
You can also add some concepts.
You can also you know add some color tags you can add data boards you can choose different other parameters
for example say other choose only top 10 percent.
An extra will only highlight the values which are in the top 10 percent.
So these are some beautiful ways of adding some beautiful conditions some beautiful graphics in your
Excel based on the parameters that you can give in the top then that you can particularly select in
the top panel here.
So these are called conditional formatting.