Conditional formatting requires creation of new style which then gets applied to the cells that fulfill the condition in the given range.
If I have a row in which different cells use different formats, then if that row gets selected as part of the condition, then the selected style gets applied to all the rows. I would like to just change the cell contents to Bold without changing the font or any other attributes (such as border, number format or date format). To explain further if one cell has font size 12, other cell has font size 8 and if the style defined for "conditional format " has font size 10 then for the selected cells having existing font size of 12 and 8 respectively, the font size changes to 10. My requirement is that keeping the existing font size, the cell contents should be made “bold”.
How can this be achieved?