Changing cell background colours

T

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
 
B

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!
 
Top