Hi,

I'm using Excel 2007.

I've been looking for a way to use formulas in order to do conditional formatting.

I'd like to format a whole line in "Bad" or "Good" depending on the value of one cell of this line ("Bad" for a "X", "Good" for a "V")

I use OpenOffice Calc at work, and it got a STYLE() function that is very convenient to use : STYLE( IF( test; "Style1"; Style2" ) )

I can't find a similar function in Excel, do you have any idea on how I could do that ?


Thanks a lot !