SOLVED

EXCEL Conditinal formatting

Copper 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.

 

Regards.

Rana

6 Replies

@RanaNaimat 

I entered conditional formatting and it seems to work.

best response confirmed by RanaNaimat (Copper Contributor)
Solution

@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.

@RanaNaimat 

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
1 best response

Accepted Solutions
best response confirmed by RanaNaimat (Copper Contributor)
Solution

@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.

View solution in original post