Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Naomi
 
Posts: n/a
Default How do I set up conditional cell fill colours in Excel?

I'm setting up a worksheet to monitor achievement against targets. I have
seen s similar system used whereby when you enter a value into the worksheet,
the cell fill colour changes depending on whether the value entered misses,
meets or exceeds the target value set. Can anyone help me with an explanation
of how to do this? Thanks
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Take a look at http://www.xldynamic.com/source/xld.CF.html

--
HTH

Bob Phillips

"Naomi" wrote in message
...
I'm setting up a worksheet to monitor achievement against targets. I have
seen s similar system used whereby when you enter a value into the

worksheet,
the cell fill colour changes depending on whether the value entered

misses,
meets or exceeds the target value set. Can anyone help me with an

explanation
of how to do this? Thanks



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
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 07:42 PM
Office2000: Conditional format behaves strangely Arvi Laanemets Excel Discussion (Misc queries) 1 April 7th 05 09:47 AM
Trying to add conditional formatting to every other cell...GOING . trixiebme Excel Worksheet Functions 2 March 24th 05 02:55 PM
Possible? formula in one cell can fill another cell Sherri Excel Worksheet Functions 3 March 24th 05 01:35 AM
Conditional formatting row if cell value in certain column is even Hyland Hunt Excel Worksheet Functions 1 February 2nd 05 09:21 PM


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

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"