Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default color of cell fill

I want to set up a mathmatical formula that will fill a cell with a specific
color that corresponds to the value the formula returns. For instance, if
the formula returns 99 - the cell would be green, if 70 it would be yellow
and if < 60 it would be red. Anyone know how to accomplish this?
--
jan
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default color of cell fill

You can do this with Format | Conditional Format while the cell is
selected (assume it is A1). Then in the panel that pops up you can
choose Formula Is rather than Cell Value Is and enter the formula:

=A1=99

(I'm assuming you want 99 or above), then click the Format button on
the panel, select the Patterms tab and choose Green, then OK. Then
click Add and set up a similar condition for:

=A1=70

and choose a yellow background, then OK and Add, and then finally your
third condition:

=A1<60

and select a Red background. Click OK twice to come out of the CF
panel.

Your normal background colour would be applied if the value in A1 is
=60 and <70.


Hope this helps.

Pete

On Oct 5, 12:28 am, janlanac
wrote:
I want to set up a mathmatical formula that will fill a cell with a specific
color that corresponds to the value the formula returns. For instance, if
the formula returns 99 - the cell would be green, if 70 it would be yellow
and if < 60 it would be red. Anyone know how to accomplish this?
--
jan



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,355
Default color of cell fill

Try using Format - Conditional Format

This will work for 3 or fewer condions. If you have more than 3 conditions,
you'll need to do it with VBA.
--
HTH,
Barb Reinhardt



"janlanac" wrote:

I want to set up a mathmatical formula that will fill a cell with a specific
color that corresponds to the value the formula returns. For instance, if
the formula returns 99 - the cell would be green, if 70 it would be yellow
and if < 60 it would be red. Anyone know how to accomplish this?
--
jan

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
when i try to fill a cell with color, nothing happens Richard L. Excel Worksheet Functions 1 June 6th 07 04:04 AM
Cell fill color aynrand1964 New Users to Excel 2 July 31st 06 12:56 AM
Fill color in a cell fastballfreddy Excel Discussion (Misc queries) 2 May 9th 06 08:51 PM
Cell Fill Color and text color - changes for recipient Shadowman13 Excel Discussion (Misc queries) 0 March 9th 06 12:32 AM
Cell Fill Color JackBScott Excel Discussion (Misc queries) 2 September 16th 05 03:50 PM


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

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"