conditional


Which of the following is not true regarding Conditional Formatting? a) You can add more than one condition to check b) You can set condition to look for Bold and apply Italics on them c) You can apply Font, border and pattern formats that meets the specified conditions d) You can delete any condition from Conditional Formatting dialog box if.



Conditional formatting in Excel is a way for you to alter how the data inside a cell looks based on the rules you choose. There are several main options in conditional formatting, including: Highlight Cells Rules This option allows you to highlight specific cells based on the rules you choose.



Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition.