EXCEL Conditinal formatting

Occasional Contributor

Ho all,


I have attached an excel file in that I want to apply conditional formatting where If F6>B6 (selling price is higher than asking price) than the cell should become yellow, I can do that one by one but don't know how to it just once and than fill the series automatically. 

if unclear it has one more sheet and instructions are there.




6 Replies


I entered conditional formatting and it seems to work.

best response confirmed by RanaNaimat (Occasional Contributor)

@RanaNaimat You can do all with one rule, applied to the entire range. So, remove all the rules apply to one singel cell. Note that the "greater than" cell reference should NOT have dollar signs in them. See attached.


As a comment. The rule for conditional formatting: one colour/format - one rule. If you use more to apply same formatting within same range you definitely may to improve something.

@Riny_van_Eekelen Thank You SO much

Thank you!
Thank You