# Condional formatting formula based on a rule?

#### SONJOE JOSEPH

##### Member
Dear Excel Experts,

I'm looking for a conditional formatting formula were the condition is if the IV price is trading above the CMP then it should be should in red color. Similarly, if the IV price is trading below the CMP then it should be in green color.

With Regards,

Sonjoe.

#### Attachments

• Problem.xlsx
11.9 KB · Views: 5
Please see attached file if it works for you.

#### Attachments

• Problem.xlsx
12.4 KB · Views: 4
Please see attached file if it works for you.
Well u have protected this sheet. so i can't view the formula. I want only the IV prices font to be changed. According to the conditions mentioned by me

Dear Excel Experts,

I'm looking for a conditional formatting formula were the condition is if the IV price is trading above the CMP then it should be should in red color. Similarly, if the IV price is trading below the CMP then it should be in green color.

With Regards,

Sonjoe.
Kindly somebody solve my query. I want the conditional formatting to be done in my excel sheet. Kindly somebody solve my query.

make up 2 rules
=\$C5>\$B5
and
=\$C5<\$B5

what happens if they are equal

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A5:C100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=\$C5>\$B5

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

repeat the rule for
=\$C5<\$B5

#### Attachments

• Problem-ETAF.xlsx
13.1 KB · Views: 0
Well u have protected this sheet. so i can't view the formula. I want only the IV prices font to be changed. According to the conditions mentioned by me
Sheet provided by @Juniad is not protected in any way

Last edited: