Syntax of Formula to change cell color

[Ironmanxp]

Hi,

Would like to understand how to write a formula that would conditionally change the format in a selected cell such as cell color and or font size/style, etc. Example syntax sample would be helpful.

Thanks

[robleyd]

You may want conditional formatting rather than a formula; open help - F1 - and search conditional formatting for more information.

If this doesn't meet your needs, perhaps you could give a bit more detail of what it is you want to achieve.

[Zizi64]

or:
You can use the Style() function in your formula. The function will aplly an existing cell style - You can use the function once in a formula, or (combined with the IF() ) conditionally.

For the numeric results. The "return value" of the function Style equals 0):

Code: Select all

= A1  + Style("MyCellStyle")

For the string results.:

Code: Select all

= A1  & T(Style("MyCellStyle"))

[Ironmanxp]

Thanks, i'll check those out.