Nov 10 2021 07:19 AM
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
Nov 10 2021 07:29 AM
I entered conditional formatting and it seems to work.
Nov 10 2021 07:34 AM
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.
Nov 10 2021 07:50 AM
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.
Nov 10 2021 07:34 AM
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.