Question

explain the conditional formatting with help of an example list any two formats that can be used for conditional formatting

Answer 1

Using Formulas In Conditional Formatting 

In addition to using the built in comparison operations from the Cell Value Is option, you can use your own custom formula to determine whether the format condition should be applied.  To use a custom formula in the format condition, change Cell Value Is to Formula Is in the CF dialog, and enter you formula in the text box that appears. You formula should return a value of either True (non-zero) or False (zero).  If your formula returns True, that format condition is applied.  If the formula returns False, the format condition is not applied, and the next (if any) format condition is tested.  

An advantage of using a custom formula in the format condition is that it allows you to change the format of one cell based on the value of another cell.   For example, if you want A1 to appear in red if cell B1 is greater than 10, you can use the formula =IF(B1>10,TRUE,FALSE) , or, more simply, =B1>10 , as the custom formula.  You can use any standard Excel worksheet formula, with the following exceptions: 

The formula cannot reference a range in another worksheet or workbook (but see below for a way to get around this)

You cannot use functions in an Add-In module. But you can call the function from a VBA function in the same workbook and return the result by calling your VBA function from your formula.



I hope help him..


please tick brainliest answer..

Answer 2

I have written it by myself please mark it as the brainllist if it will help you please say thanks for this answer too. . .