Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
JP JP is offline
external usenet poster
 
Posts: 103
Default formula to change back ground cell color according to a value

I need a formula to change the back ground color of a cell according to a
certain value
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9,101
Default formula to change back ground cell color according to a value

You don't use a formula for this, uyou use conditional formating. On the
worksheet menu use Format - Conditional Formating. Select either "Cell Value
Is" or "formula Is".

"JP" wrote:

I need a formula to change the back ground color of a cell according to a
certain value

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
How do I put a back ground word on a sheet in Excell Scrapironmike Excel Discussion (Misc queries) 1 October 17th 07 07:10 AM
Excel spreadsheet change colour of cell back ground depending on d Nataliec Excel Discussion (Misc queries) 1 September 12th 07 12:12 PM
How to set a back ground picture in an exel file Divya Excel Worksheet Functions 2 June 30th 06 06:03 PM
back ground color doesn't work in cell. Soother Excel Worksheet Functions 1 October 7th 05 02:14 AM
Change cell back color on click Dave Peterson Excel Discussion (Misc queries) 0 January 24th 05 10:50 PM


All times are GMT +1. The time now is 01:09 PM.

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

About Us

"It's about Microsoft Excel"