Changing cell background colours

[Tim Adams]

I'm trying to change the background colour of a cell,
based on the outcome of an @IF statment. For example:

@if(x=y,"make backgound colour yellow")

Any ideas on how to do this would be appreciated!


Thanks!

Tim

 

[Big Chris]

The Conditional Formatting under the 'Format...' menu option is great so
long as the likely number of returned values doesn't exceed 3.
You can for instance have a yellow background if the rurned number is
less than 100 or a red background if it is greater than 100....and a
blue background if it's exactly 100!

 

[Danny]

Use conditional foramtting from the format menu.