Forum Discussion
Clearing formatting with conditional formatting
Hi Damian,
Could you please share in more details which exactly rule do you use. If, for example, like
=OR($A1="Subtotal",$A1="Grand Total")
applied to entire range it shall work correctly when you insert more rows.
Ok. I've just confirmed that I have some problems with my eyes ...
Myster solved. For the record formula was not the problem, but type of formatting. I had to set formating to "Regular".
For some who want to study this case, one of the aproaches is to set formatting as "Regular" for for cells that are in the row where column B is not empty.
Formula:
=$B2<>""
Range of formating:
=$A$2:$K$1000
Other aproach is, as Sergei sugested, to set formating for rows which are not "Subtotal" or "Grand Total" in column A.
Formula:
=OR($A2<>"Subtotal",$A2<>"Grand Total")
Range stays the same:
=$A$2:$K$1000
I need more coffe ;)
Could be this way or conversed (apply Bold with opposite rule).
Anyway, it works, so far so good.
Bon Appetit!
Bolding rule was already working. Problem was when a new row with new date in column B and data in rest of columns was added.
The rows with totals were moving down and they ware bolded. But without the rule clearing bolding for rows that previously holded totals and now are just data.
This is specific situation where row is added only in columns from A to B. Rest of the columns holds formulas that fills the cells with values depending on content of the columns A and B.
