Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Macca
 
Posts: n/a
Default Background Colour Depending On Input

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

Any help greatly appreciated :-)
  #2   Report Post  
Posted to microsoft.public.excel.misc
macropod
 
Posts: n/a
Default Background Colour Depending On Input

Hi Macca,

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

Cheers


"Macca" wrote in message
...
Im looking for the formula that changes the backgound colour of a cell
depending on the data input.

Any help greatly appreciated :-)



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Countif background colour is..... ruthhicks999 Excel Worksheet Functions 3 March 14th 06 01:31 PM
How can i change cell colour depending on month of date in cell? andy75 Excel Discussion (Misc queries) 2 January 6th 06 07:46 AM
Background colour grey on entire worksheet Inserting an option button in Word Excel Discussion (Misc queries) 3 July 14th 05 01:49 PM
Counting cells with a specific background colour Duncan Excel Discussion (Misc queries) 2 June 16th 05 11:04 PM
establishing the background colour of a cell ac512 Excel Discussion (Misc queries) 4 April 15th 05 08:20 PM


All times are GMT +1. The time now is 06:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"