2010/8/28 Jean-Baptiste Faure <[email protected]>: > Le 28/08/2010 16:44, Andy Chaplin a écrit : >> >> Hi all >> >> As far as I can see it's only possible to have 3 levels of conditional >> formatting. Does anyone know of a trick or workaround to get more >> conditions to apply. Ideally i would like six and any suggestions >> would be gratefully appreciated. > > You can use formula with nested IF() and STYLE() functions. > > JBF > Absolutely. And if you want different formats for different text strings, such as names if people or something, you can create a style with the same name for each person and just add the style directly… For example: =Sheet1.A1 + STYLE(A1) Except that if Sheet1.A1 is empty, 0 will be displayed rather than an empty cell.
The following might work: =IF(Sheet1.A1="";"";STYLE(A1)) But I don't know if this is doable in Andy’s situation. Regards Johnny Rosenberg --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
