Result changes cell color

Is there a way to fill a cell with a color depending on the result?

Basically,  I want the following:

If cell = 1  Fill cell with Red
If cell = 2  Fill cell with Yellow
If cell = 3  Fill cell with Green

Thanks for any help. 


0
genie1 (2)
11/28/2004 6:18:02 PM
excel 39879 articles. 2 followers. Follow

3 Replies
535 Views

Similar Articles

[PageSpeed] 6

format>conditional format>easy from there

-- 
Don Guillett
SalesAid Software
donaldb@281.com
"GSBohn" <genie@cfl.rr.com> wrote in message
news:uDoqd.47388$Oc.10064@tornado.tampabay.rr.com...
> Is there a way to fill a cell with a color depending on the result?
>
> Basically,  I want the following:
>
> If cell = 1  Fill cell with Red
> If cell = 2  Fill cell with Yellow
> If cell = 3  Fill cell with Green
>
> Thanks for any help.
>
>


0
Don
11/28/2004 6:34:12 PM
Hi
see Format - Conditional Format for this

--
Regards
Frank Kabel
Frankfurt, Germany

"GSBohn" <genie@cfl.rr.com> schrieb im Newsbeitrag
news:uDoqd.47388$Oc.10064@tornado.tampabay.rr.com...
> Is there a way to fill a cell with a color depending on the result?
>
> Basically,  I want the following:
>
> If cell = 1  Fill cell with Red
> If cell = 2  Fill cell with Yellow
> If cell = 3  Fill cell with Green
>
> Thanks for any help.
>
>

0
frank.kabel (11126)
11/28/2004 6:34:47 PM
Thanks so much.  That did it.



"Frank Kabel" <frank.kabel@freenet.de> wrote in message 
news:Owd73iX1EHA.2824@TK2MSFTNGP09.phx.gbl...
> Hi
> see Format - Conditional Format for this
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
> "GSBohn" <genie@cfl.rr.com> schrieb im Newsbeitrag
> news:uDoqd.47388$Oc.10064@tornado.tampabay.rr.com...
>> Is there a way to fill a cell with a color depending on the result?
>>
>> Basically,  I want the following:
>>
>> If cell = 1  Fill cell with Red
>> If cell = 2  Fill cell with Yellow
>> If cell = 3  Fill cell with Green
>>
>> Thanks for any help.
>>
>>
> 


0
genie1 (2)
11/28/2004 9:41:51 PM
Reply:

Similar Artilces:

Changing chart types with series
Hi, I currently have a graph comprised of 4 different series. 2 of the series are bar graphs, 2 others are line graphs. The problem is that one of the bar graphs is overtop of the other bar graph meaning I can't see that series. I've tried going in and changing it by changing the overlapped bar graph to a line graph but I can't seem to do it. I've right clicked, selected chart types but I can't change only 1 series of the graph. Is there anyway to do this? Thanks, -- miteeka Sounds like one column is on the primary and the other is on the secondary axis. You need ...

Macro
Hello, I'm trying to sum certain cells in macro, however, the cell range is not fixed;(i.e cells are based on variables) Herebelow is an example of the macro but it's giving an error at the sum funtion (would appreciate if you could help me find the mistake): Sub R() Dim i As Integer, x As Integer, y As Integer, z As Integer For i = 2 To 15 y = i - z x = i - 1 Cells(i, "H").Formula = "=Sum(Cells(y, "H"), Cells(x, "H"))" z = 0 y = 0 x = 0 Next i End Sub Thank you How about: Option Explicit ...

Please help me decipher the result of COUNT.
Following data from A1:A7 Sales 12/8/2008 19 22.24 TRUE #DIV/0! =COUNT(A1:A7,2) returns 4. I don't understand where the four occurrences of 2 come from. 22.24 = 3 occurrences 12/8/2008 = 2 occurrences total of 5?? I know I am missing something. Please tell me. Is there a tool that I can use to trace? I tried the formula auditing toolbar, no luck because there is no error and trace precedents is not detailed enough. Appreciate explanation. Epinn have a look in the help index for COUNT -- Don Guillett SalesAid Software dguillett1@austin.rr...

If statement result appearing in different colors
Is there a way to write an IF statement where the text will change color depending on the result? eg =if(x=0,"RED-colored text","BLACK-colored text") where 'RED-colored text' would appear in RED, etc Thank You! WayneD Take a look at Format|Conditional formatting. WGD wrote: > > Is there a way to write an IF statement where the text will change color > depending on the result? eg > > =if(x=0,"RED-colored text","BLACK-colored text") where 'RED-colored text' > would appear in RED, etc > > Thank ...

Conditional Formatting using result of Cell Formulas
Hi, I'm trying to make a conditional format when the result of a formula results in a value being entered in a cell. I'm using Excel Xp and my formula is as follows. =IF(F160="Need Info",TODAY()-S160,"") I've tried using formulas like >0, <>"", <>BLANK etc. but they all seem to fail. All cells are formatted, even entirely blank cells, as if the condition has been met. BTW, is this formula better strategically than the above formula. =IF(F160<>"Need Info","",TODAY()-S160) Just curious. TIA!!! Norm If ...

Count results from query with no results
I have continous form with an unbound text box [keyword] and a button [search]. There is also an unbound textbox [numberofresults] that counts the number of records returned. If the search produces no results, the [numberofresults] needs to read 0, instead it is just blank. What is the proper way to show zero results as 0 and not blank? It depends on how you are doing your search? Do you have a function? Are you just filtering the recordset? Dale -- email address is invalid Please reply to newsgroup only. "Ryan Tisserand" wrote: > I have continous form with an un...

changing CRichEditView color without changing the selection?
I'm trying to change the color of a portion of text inside a CRichEditView control. The only way that i know of to do this is to highlight the text and then set the character formatting to change the color. Just wondering if there is a way to avoid highlighting the text and yet be able to colorize it? Refer http://www.codeproject.com/richedit/htmlricheditctrlssl.asp "MrPolite" <kderakhshanAtMSN@msn.com> wrote in message news:OUMPf.6536$e1.235@tornado.socal.rr.com... > I'm trying to change the color of a portion of text inside a CRichEditView > control. T...

how do I change a cell permanently to PM from AM?
I would like to do this permanently to the template, so that I have timesheets that I don't hav eto change everytime I input my time data. Thx The question is not clear so here are some suggestions B1: =A1-0.5 A1: 11:00 PM ---> B1: 11:00 AM =IF(A1>0.5,A1-0.5,A1) Menu:Data>Validation... Allow:Time, Data:Less then or Equal to, End time: 12:00 Hope it helped Ola Sandstr�m -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17760 View this thread: http://www.ex...

How to paste Conditional Formatting to other cells but using different data cell
I've made a spreadsheet that has a column for days of testing and another column that calculates the actual days it took for testing. Each row has a different day requirment of when testing should be complete. How can I format the column of "actual days of testing" to color the cell in red with bold type when the value of this cell is greater than the cell of "days of testing"? I tried conditional formating, but this only works for one row, when I tried to paste the format to other cells it used the data source from the first row. It would be too time consuming to indiv...

sql result different to excel result
Hi, Just wondering why I am having such problems rounding figures, when I round the same figure on an Excel Sheet, I end up with a different end result to what appears in sql. The Excel Looks Like This. Net Vat Total Allocated Result (=(NET+VAT)/Allocated*Total) 900.00 157.50 1721.38 1721.38 1057.50 150.00 26.25 1721.38 1721.38 176.25 The Result field is a calculated field and is rounded to 2 decimal places, the calculation is in brackets next to the title name. The Table in SQL has the same structure but the net, vat,...

Visual Basic:Change on event
I wish to reset the properties of several worksheet controls on the entry into a cell. The visual basic help suggests using Sub Worksheet_Change(ByVal Target as Range) End Sub What is the syntax to be used here is it Sub Worksheet_Change(ByVal .Range("C11"))? or Sub Worksheet_Change(ByVal .Range("C11") as Range)? Sub Worksheet_Change(ByVal ("C11") as Range)? I am using Excel 2004 on OSX 10.4 Thanks Brujolito put in the SHEET module private Sub Worksheet_Change(ByVal Target as Range) if target.address="$A$11" then do your thing end if End Sub ...

Why does change in IV00102 update DEX_ROW_TS in IV00101?
We've had some performance problems since upgrading to GP10. In researching this problem I discovered that the item quantities table, IV00102, has an AFTER UPDATE trigger called zDT_IV00102U that updates the item master table, IV00101 (specifically, it is setting IV00101.DEX_ROW_TS to the current date and time). We had auditing set up on IV00101, thinking that auditing changes in a master table would not have much impact on performance, but because of this trigger every time a document posts that changes inventory quantities our auditing on IV00101 fires also. What is th...

Changing the System Date
Hi there, can anyone tell me the code for changing the System date from the program. thanks >can anyone tell me the code for changing the System date >from the program. Try the SetSystemTime API. Dave -- MVP VC++ FAQ: http://www.mvps.org/vcfaq In article <ab0f01c43674$05e05270$a101280a@phx.gbl>, anonymous@discussions.microsoft.com says... > Hi there, > > can anyone tell me the code for changing the System date > from the program. SetSystemTime changes the date. On NT-based systems, you'll have to enable the SE_SYSTEMTIME privilege before that can succee...

How do I change the column headings in Excel?
I have a new computer at work and when I opened excel, i found the columns are labeled with numbers, just like the rows. This is very confusing. How do I change them back to letters like it should be? Go to Tools>Options>General and uncheck the R1C1 Reference Style checkbox. -- HTH RP (remove nothere from the email address if mailing direct) "scmagnum" <scmagnum@discussions.microsoft.com> wrote in message news:9AC61354-D38F-44F5-BBC9-C25AEF3C6186@microsoft.com... > I have a new computer at work and when I opened excel, i found the columns > are labeled wi...

Change the mail Subject
When I choose to send my SOP Blank Invoice Form to a mail recipient (pdf), information is populating the subject line and body of my e-mail by default. Specifically the name of the report is populating the subject line. Is there a way to change this? I would rather see the Invoice number or customer name populating that field. Thank you Nancy, Out of the box, no. When you print a report to screen it loses all knowledge of what report it is (or where it came from). That's why when you then send to pdf the best the window can do is use the title of the output window as the s...

Updating cells using input boxes
Hi all My problem is that i am using Input boxes to update a spreadsheet. I have two coloums i want to update for two diffent type of information. I am currently trying to use Sub Compfees() MyInput = InputBox("Enter Students Name") Range("Sheet1!N20").End(xlDown).Offset(1, 0).Value = MyInput MyInput = InputBox("Enter Fee") Range("Sheet1!O20").End(xlDown).Offset(1, 0).Value = MyInput End Sub But this seems to update the first colum ok and move down updating as required, but it just replaces the value in the second coloum and doesn't move ...

why cut and insert cells only works randomly?
It seems that cutting and inserting cells in the spreadsheet, errors every other time and locks the excell spread sheet... Hi Tony, You'll have to be more specific, but you might find the answers to such problems as inserting rows, using OFFSET with formulas. And you will probably find why extending formulas and does not work for you. -- if any of those are the problem. http://www.mvps.org/dmcritchie/excel/insrtrow.htm I don't know what you mean by locking the sheet, have you turned on sheet protection or have merged cells in your copy.. --- HTH, David McRitchie, Microsoft...

Cell comments
Hi there, Is there any way to stop cell comments resizing when inserting new rows above or below the cell with the comment, as at the moment if I insert a row above a row which has a cell with a comment, the comment will resize in height and it's very very very annoying. Thanks! -- flib ------------------------------------------------------------------------ flib's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15323 View this thread: http://www.excelforum.com/showthread.php?threadid=269492 You could set the properties of the comment so it doesn't s...

How to replace a function with its result or resulting reference in a formula?
Hello How to replace a function with its result in a formula? For example, =INDEX(...)+INDEX(...) with =result_of_INDEX(a...)+result_of_INDEX(b...)=1025+1307. How to replace a function with its resulting reference in a formula? For example, =HLOOKUP(1...)+HLOOKUP(2...) with =b11+z11. I need to replace in 1000 cells automatically. "Dmitry Kopnichev" <kopn@bk.ruDelete> �������/�������� � �������� ���������: news:%23cF5PL9zFHA.916@TK2MSFTNGP10.phx.gbl... > Hello > How to replace a function with its result in a formula? For example, > =INDEX(...)+INDEX(...) with > =r...

Pivot Table not populating cells
I have a set of data which I need to put into a PT: Level 1 is Surname and level 2 is First Name. I've sorted it within the PT by Surname then First name. I have 15 instances of the name Jones. When the PT is produced it only shows one instance of th word Jones and then the rest of the lines below (ie the other 14) have no data. The next column to the right has all 15 First names but the only one with Jones next to it, is the first one. How can I get my PT to show ALL surnames next to all the first names please? Thanks in advance, AW The row headings show once in a Pivot Tab...

Formula to return numerical, text result?
I need to create a formula that based upon three possible factors, wil return one of two calculations or a text message. If cell B="Good", the formula in cell C returns "Text" If cell B="Better", the formula in cell C returns cell A*.3 If cell B="Best", the formula in cell C returns cell A*.5 Thanks in advance for any tips -- burgeo ----------------------------------------------------------------------- burgeon's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2023 View this thread: http://www.excelforum.com/showthread.php...

Single click selects multiple cells
When clicking on a single cell multiple cells are selected. The one time solution for this is to zoom in or out. This is problematic as 60% seems to be the zoom that works most of the time but at this zoom level the cell contents do not display. The time lost and the frustration that builds is killing my productivity and office attitude. Please give all of us a permanet fix. -- Thanks Mike ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" butt...

Hide results
I am putting together a summary spreadsheet of dates from seperate worksheets in an excel file. In the summary sheet I reference the 'end' date from the summary sheet. If there is no date in the original file, what formula can I use to leave that cell blank/hide on the summary sheet? The way I have it now the results show the default of 1/0/1900 Here is the formula used to reference the info from. =Summary!K5 =IF(Summary!K5="","",Summary!K5) -- David Biddulph "bigred72" <bigred72@discussions.microsoft.com> wrote in message ...

Sum in another cell with reference to another
I need to add cells which only have reference to another eg: PNS Kilbirnie 2.0 NW Newtown 1.0 NW Island Bay 1.5 NW Metro 1.0 PNS Kilbirnie 1.0 eg: Need to add only the "PNS Kilbirnie" totals but these are also in other columns similar to above. At the moment these two columns are A & B, then I need to also add the Kilbirnie from column C & D as per above -- Shirl, NZ One way to get this delivered in 10 secs. Do a 5 sec copy/paste stack up of the data in cols C & D below that in col A & B, then create a pivot on the combined data, placing the ...

Rounding actual results
Hi, I've got a grid that says: Hr Min Maths: 5 25 English: 7 25 And so on. I'm wanting to work out how much time is devoted to learning in the whole week. What I've got so far is: Hr Min Total learning time: =A1+A2... (counts up all totals in hours column) My current answer for hours is 18. I'm stuck with what to do with the minutes column. so far, I've got an ...