[shhftw]

Can you use the formatting of another cell (say bold or italics) or count the number of such formatted cells in a range (or array) in another formula in a seperate cell?

I hope I've asked that right. The cells are already conditionally formatted (background fill) by their value.

[shhftw]

Originally Posted by shhftw

Can you use the formatting of another cell (say bold or italics) or count the number of such formatted cells in a range (or array) in another formula in a seperate cell?

I hope I've asked that right. The cells are already conditionally formatted (background fill) by their value.

It seems CELL(FORMAT,<reference>) is only able to return a character based on the number format, not on the cell character format - close but no cigar...

[alanwarwic]

I don't have it loaded but surely F1 brings up HELP to then allow a list of Functions.
Luckily the F1 key was not patented by Microsoft for their use only.

[dadioflex]

Is this possibly what you're looking for?

http://help.libreoffice.org/Calc/Ass...ats_by_Formula

Can't find a better explanation of the "style" command but it might be what you're after. Honestly well out of my depth here. I never even knew about conditional formatting before - now a whole new world is open to me...