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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change background colour 3
Cell text and background colour dependant on result 1
Change the colour 1
Cell Formatting of a Conditional Statement 3
Excel 2007 conditional formatting & cell colour. 2
Coloured backgrounds using IF 3
Counting coloured cells? 1
Cell Coloring 2

Back
Top