Changing cell background colours

  • Thread starter Thread starter Tim Adams
  • Start date Start date
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
 
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!
 
Back
Top