How do I make conditional formatting based on another cell?



How do I make conditional formatting based on another cell?..

Answer / Nitin Azad

"Select the range of cells you want to format, click on Home > Conditional Formatting, choose a rule or New Rule, select 'Use a formula to determine which cells to format', input your desired formula (e.g., =$A2>10), and click OK."n

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do you combine text in excel?

1 Answers  


What is excel right?

1 Answers  


How do I merge data from excel to word?

1 Answers  


How do I enable links to an external workbook in excel?

1 Answers  


Where is the developer tab in excel?

1 Answers  


What is spreadsheet in ms excel?

1 Answers  


What is the difference between lookup and vlookup?

1 Answers  


How can I tally master data in excel?

1 Answers  


How to go to bottom of excel spreadsheet?

1 Answers  


How do I check if a value is equal in excel?

1 Answers  


How do you use the or function in excel?

1 Answers  


What is ms excel 2010?

1 Answers  


Categories