If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
if functions-Can you format cells?
Format / Conditional Formatting - Put in the two conditions and choose the two
results you want to occur when each condition is true. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Deb" wrote in message ... Hi, Is it possible to use an if function to color a cell? If the value of a cell is greater than .5 shade it red, less than .5, blue? Thanks, Deb --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.598 / Virus Database: 380 - Release Date: 28/02/2004 |
#2
|
|||
|
|||
if functions-Can you format cells?
I've tried and I can't get it to work.
----- Ken Wright wrote: ----- Format / Conditional Formatting - Put in the two conditions and choose the two results you want to occur when each condition is true. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Deb" wrote in message ... Hi, Is it possible to use an if function to color a cell? If the value of a cell is greater than .5 shade it red, less than .5, blue? Thanks, Deb --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.598 / Virus Database: 380 - Release Date: 28/02/2004 |
#3
|
|||
|
|||
if functions-Can you format cells?
It is not a very good answer, when you say I tried and you can't get it to
work, what happened? Nothing? Got an error message? PC exploded? Select the cell, do formatconditional formatting, cell value is greater than or equal to 5, click format button and select the formatting, click OK, click add button, repeat but use less than 5, format, click OK twice. If the value is 5 and you don't want any formatting change the first to cell value greater than 5 -- Regards, Peo Sjoblom "Deb" wrote in message ... I've tried and I can't get it to work. ----- Ken Wright wrote: ----- Format / Conditional Formatting - Put in the two conditions and choose the two results you want to occur when each condition is true. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 00/02/03 --------------------------------------------------------------------- ------- It's easier to beg forgiveness than ask permission :-) --------------------------------------------------------------------- ------- "Deb" wrote in message ... Hi, Is it possible to use an if function to color a cell? If the value of a cell is greater than .5 shade it red, less than .5, blue? Thanks, Deb --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.598 / Virus Database: 380 - Release Date: 28/02/2004 |
#4
|
|||
|
|||
if functions-Can you format cells?
Hi Deb!
Select the cell Format Conditional formatting Cell Value Is Select: "greater than" 0.5 Press Format button Click Pattern tab Select your colour OK Press Add Cell Value Is Select: "less than" 0.5 Press Format button Click pattern tab Select your colour OK OK Note that 0.5 will not be coloured because it is not greater than 0.5 or less than 0.5. If you don't intend this, then vary the condition that you select or give it a third conditional format. -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Deb" wrote in message ... I've tried and I can't get it to work. |
#5
|
|||
|
|||
if functions-Can you format cells?
Select A1, then
Format. ConditionalFormat Expand the first window, and click "Formula Is" In the next window enter, =AND(A10,A10.5) Then click on the Format button, Patterns tab, Click a blue you like, then OK Now, click Add Leave the first window "CellValueIs", Expand the next window and choose "Greater Then" Enter 0.5 in the third window. Then click on the Format button, Patterns tab, Click a red you like, then OK OK. Just a comment. You have not chosen any format if the cell is *exactly* 0.5 ! You can now click A1,and drag down to copy as needed. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Deb" wrote in message ... I've tried and I can't get it to work. ----- Ken Wright wrote: ----- Format / Conditional Formatting - Put in the two conditions and choose the two results you want to occur when each condition is true. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 00/02/03 ----------------------------------------------------------------------- ----- It's easier to beg forgiveness than ask permission :-) ----------------------------------------------------------------------- ----- "Deb" wrote in message ... Hi, Is it possible to use an if function to color a cell? If the value of a cell is greater than .5 shade it red, less than .5, blue? Thanks, Deb --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.598 / Virus Database: 380 - Release Date: 28/02/2004 |
#6
|
|||
|
|||
if functions-Can you format cells?
Would like to correct the first conditional formula to:
=AND(A10,A10.5) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "RagDyeR" wrote in message ... Select A1, then Format. ConditionalFormat Expand the first window, and click "Formula Is" In the next window enter, =AND(A10,A10.5) Then click on the Format button, Patterns tab, Click a blue you like, then OK Now, click Add Leave the first window "CellValueIs", Expand the next window and choose "Greater Then" Enter 0.5 in the third window. Then click on the Format button, Patterns tab, Click a red you like, then OK OK. Just a comment. You have not chosen any format if the cell is *exactly* 0.5 ! You can now click A1,and drag down to copy as needed. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Deb" wrote in message ... I've tried and I can't get it to work. ----- Ken Wright wrote: ----- Format / Conditional Formatting - Put in the two conditions and choose the two results you want to occur when each condition is true. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 00/02/03 ----------------------------------------------------------------------- ----- It's easier to beg forgiveness than ask permission :-) ----------------------------------------------------------------------- ----- "Deb" wrote in message ... Hi, Is it possible to use an if function to color a cell? If the value of a cell is greater than .5 shade it red, less than .5, blue? Thanks, Deb --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.598 / Virus Database: 380 - Release Date: 28/02/2004 |
Thread Tools | |
Display Modes | |
|
|