Condional formatting formula based on a rule?

[SONJOE JOSEPH]

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.

The working file is attached along with the msg. Please help me.

With Regards,

Sonjoe.

 

[Juniad]

Please see attached file if it works for you.

 

[SONJOE JOSEPH]

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

 

[SONJOE JOSEPH]

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.

The working file is attached along with the msg. Please help me.

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.

 

[ETAF]

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

 

[pecoflyer]

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