Learn all  about Microsoft Excel !   

Microsoft Excel  Do you need specific attention ?

Learn all  about  Outlook !  

Microsoft Outlook Do you need specific attention ?

Learn all  about Microsoft PowerPoint ! 

       

Microsoft Powerpoint  Do you need specific attention ?  

Learn all  about Power BI ! 

Microsoft Power bi   Do you need specific attention ?

     Learn all about Microsoft Access ! 

Microsoft Access  Do you need specific attention ?

Learn how to use : Conditional Formatting in excel ! enjoy the free lessons Excel 2017

Learn how to use : Conditional Formatting in excel:
In this   article  the idea  is  related  to Conditional Formatting:
You can  find  it  here  as  below – under  Home  tab.  


This menu contains some amazing  options – see  below  : each  one  of  those  are  affecting  Cells'  appearance and  based  on  the same Cells' Value-   keep  reading to  get more details.


To understand more  we  will  work  on  a small  exercise:  the  goals  will  answering on what  to do  to  pass  from  the  below  first table  to  the  second one ? 
We  have  5 columns  and  20 lines – the  properties  of  each  column’s  data   are like this : (C: Product  N°  and  C:  Class ) =  Text  ,  (C: Volume)  =  number  (C:Price/unite and  C: Total cost) = Accounting.  this   information is  important  for  conditional  formatting  menu- you will see later.


Below  I will  explain  what to  do  for  each  column  separately :

Column  “Product”  :  we  need  to check  if  there  is  some  duplicated  product  N°  and  in case there  is  one , we need to  give  to the  Cells  that  contain  duplicated  value a specific  color  or  character.
For  that  we  set  the  below  steps:
  • Select  the column  “product”  - title  not  included- then click : 


  • After that you will have this message box which you need to fill it as shown here. 



Column  “Class”    : we  need  to give color red to cells contain letter A,  yellow for Cells contain B and green for C. to do that here the step to folow:

  • Select New rule from Conditional formatting :

  • You will  get the below boxes which you need to fill it as below: 


Once this is done you can check and edit the rules you just created:




Columns  “volume ”  and  Price/ unite - total cost   :  all you need to do is selecting the columns and then choose the adequate format. for our exemple here below the selected formats: 


  •  Column  “volume    :    




  •  Column Price/ unite - total cost   : 


At the end, you can see your work done well and listed as below, remeber that you can always change and modify all those rules via "Edit Rule" and you can even add a new one via "New Rule".


Thanks for reading and try it by yourself. I will be glad to see your comments.