To apply conditional formatting based on the values of multiple cells. In other words, format a cell where formatting cell is different and conditional cell is different.
Click on the cell where you want to apply for formatting
Go to Home on the Ribbon, then select Conditional Formatting.
Then select the last option, "Use a formula to select which cell to format"
Now, in the formula cell write the formula for your condition
2. Conditions on multiple cells
What if you have to consider multiple cells for the condition?
Condition cell 1: Value less than 10
Condition cell 2: Value equal to "Krishna"
You need to build a formula with multiple conditions using AND operator. Based on your requirement, you can also use OR operator. Not just AND and OR, you can use any of the available functions in the MS Excel. The overall result should be TRUE or FALSE. It does not matter how complex your formula is, what does matter is the return value.
Now, build this formula and paste it in the conditional formatting formula bar.
=AND($B$6<10 b="" rishna="">10>