Forum Discussion
Clearing formatting with conditional formatting
Hi,
I have problem with clearing formating with conditional formatting. Lets say I have few columns with data and and first column contain category name (only first row in list of data of that category) or "Subtotal" or "Grand Total" or nothing. I've set conditional formating to bold total rows with formula (if first column = "Subtotal" or "Grand Total"). When the data changes some rows are added and the totals rows moves down and the new total rows are bolded (thats good). But rows that just to be totals also stay bolded and the should be normal. Is ther any conditional formating that can fix this?
4 Replies
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!
