In front of Apply Styles, select the desired style in the list or chose New Style to create one.Ĭlick the Add button to add another condition, click the Remove button to remove a condition. Select a condition in the drop down list for the format to be applied to the selected cells and enter the value. If you select All cells, see Color Scale, Data Bar or Icon Set explanations below, depending on which visual representation the conditional formatting should be represented. Specify if conditional formatting is dependent on one of the entry listed on the drop down box: You can define as many conditions as you want. Choose Data - Calculate - AutoCalculate (you see a check mark next to the command when AutoCalculate is enabled). To apply conditional formatting, AutoCalculate must be enabled.
0 Comments
Leave a Reply. |