Huwebes, Enero 22, 2015

Conditional Formatting

  1. Conditional formatting is a feature of Excel which allows you to apply a format to a cell or a range of cells based on certain criteria. For example the following rules are used to highlight cells in the conditional_format.py example: worksheet.
  • Highlight Rules 
  • Top/Bottom Rules 
  • Data Bars 
  • Color Scales 
  • Icon Sets Add your new rule!


Adding New Rule 
 - add a formula that contains a
condition and add new formatting. 
Ex: =A1=“True”


Sources:
http://moodle.pshs-brc.edu.ph/
office.microsoft.com

Walang komento:

Mag-post ng isang Komento