| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
font color depends on a number
I have a number in A1 :the font color=black
If I place a "1" in B1 I want the font color in A1 to turn to RED and consequently place a "2" in B1 would return tje font color to black Please help & Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
font color depends on a number
What if B1 is neither 1 or 2? If we assume that B1 will always be 1 or 2,
select A1, do formatconditional formatting, in the formula is box type =B1=1, click the format button, select fonts and a red colour, click OK twice. If you have Excel 2007 post back -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "pcor" wrote in message ... I have a number in A1 :the font color=black If I place a "1" in B1 I want the font color in A1 to turn to RED and consequently place a "2" in B1 would return tje font color to black Please help & Thanks |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
font color depends on a number
Yes I do have Excel 2007
"Peo Sjoblom" wrote: What if B1 is neither 1 or 2? If we assume that B1 will always be 1 or 2, select A1, do formatconditional formatting, in the formula is box type =B1=1, click the format button, select fonts and a red colour, click OK twice. If you have Excel 2007 post back -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "pcor" wrote in message ... I have a number in A1 :the font color=black If I place a "1" in B1 I want the font color in A1 to turn to RED and consequently place a "2" in B1 would return tje font color to black Please help & Thanks |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
font color depends on a number
Select A1, make sure you are in the home tab, click the dropdown on the
conditional formatting button, select new rule, select "use a formula to determine which cells to format", in the "Format values where this formula is true:" box put =B1=1, select format , fonts and a red font, click OK twice -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "pcor" wrote in message ... Yes I do have Excel 2007 "Peo Sjoblom" wrote: What if B1 is neither 1 or 2? If we assume that B1 will always be 1 or 2, select A1, do formatconditional formatting, in the formula is box type =B1=1, click the format button, select fonts and a red colour, click OK twice. If you have Excel 2007 post back -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "pcor" wrote in message ... I have a number in A1 :the font color=black If I place a "1" in B1 I want the font color in A1 to turn to RED and consequently place a "2" in B1 would return tje font color to black Please help & Thanks |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
font color depends on a number
Worked GREAT. Many thanks
"Peo Sjoblom" wrote: Select A1, make sure you are in the home tab, click the dropdown on the conditional formatting button, select new rule, select "use a formula to determine which cells to format", in the "Format values where this formula is true:" box put =B1=1, select format , fonts and a red font, click OK twice -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "pcor" wrote in message ... Yes I do have Excel 2007 "Peo Sjoblom" wrote: What if B1 is neither 1 or 2? If we assume that B1 will always be 1 or 2, select A1, do formatconditional formatting, in the formula is box type =B1=1, click the format button, select fonts and a red colour, click OK twice. If you have Excel 2007 post back -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "pcor" wrote in message ... I have a number in A1 :the font color=black If I place a "1" in B1 I want the font color in A1 to turn to RED and consequently place a "2" in B1 would return tje font color to black Please help & Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart formula style depends on number of sheets.... | Charts and Charting in Excel | |||
| change font color if number Range changes | Excel Worksheet Functions | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
| My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
| How to make the cell or font color red if the number is negative? | Excel Worksheet Functions | |||
Linear Mode
