FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Apply conditional formatting based on text in a cell Click HOME > Conditional Formatting > Highlight Cells Rules > Text that Contains. In the Text that Contains box, on the left, enter the text you want highlighted.

Detailed explanation-2: -Expert-Verified Answer The statements are true for conditional formatting to Add more than one condition and Apply background formats that satisfy specific conditions.

Detailed explanation-3: -Solution(By Examveda Team) In Conditional Formatting we cannot set condition to look for Bold and apply Italics on them.

Detailed explanation-4: -Excel’s predefined conditional formatting, such as Data Bars, Color Scales and Icon Sets, are mainly purposed to format cells based on their own values. If you want to apply conditional formatting based on another cell or format an entire row based on a single cell’s value, then you will need to use formulas.