Background Colour Depending On Input

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im looking for the formula that changes the backgound colour of a cell
depending on the data input.

Any help greatly appreciated :-)
 
Hi Macca,

You can use Conditional Formatting for this - see under Format|Conditional
Formatting.

Cheers
 

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

how do i change cell background colour depending on its content? 2
format cells depending on value range 5
Conditional formatting in Excel 2010 2
Can you put in anything so rest of row changes colour? 9
DATA VALIDATION INPUT MESSAGE 6
get cell to automatically change colour depending on text in adja. 1
Fill Colour problem 2
set transparent colour in powerpoint 2007 1

Back
Top