Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
in excel, how do i get cell "A1" font to red when cell "A2" says h
in excel, how do i get cell "A1" font to red when cell "A2" says hot, and so
on down the list also how do i get cell "A1" font to green when cell "A2" says cold?????? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
in excel, how do i get cell "A1" font to red when cell "A2" saysh
Hi,
Select cell A1, go to Format-conditional formatting and choose 'Formula is' and type =IF($A$2="Hot",TRUE,FALSE) and choose the format you need. and then add a condition, choose 'Formula is' and type =IF($A$2="Cold",TRUE,FALSE) and choose the format you need. Regards Govind Clownguy wrote: in excel, how do i get cell "A1" font to red when cell "A2" says hot, and so on down the list also how do i get cell "A1" font to green when cell "A2" says cold?????? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
in excel, how do i get cell "A1" font to red when cell "A2" says h
Clownguy Wrote: in excel, how do i get cell "A1" font to red when cell "A2" says hot, and so on down the list also how do i get cell "A1" font to green when cell "A2" says cold?????? Format Cell A1 as follows: 1. Go to "Format/Conditional Formatting" 2. For Condition 1, choose "Formula Is" 3. On the next box to the right, enter *=A2="hot"* 4. Click "Format" 5. Choose color Red (Color box is located somewhere in the middle) 6. Click OK 7. Click ADD 8. For condition 2, do steps 1 through 5 with the following differences: *** for step 3, enter *=A2="cold"* *** for step 5, choose color Green 9. Click OK 10. Click OK Hope this is what you need. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=504266 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
in excel, how do i get cell "A1" font to red when cell "A2" says h
Select A1, then go to Format/Conditional Formatting, then select "formula is"
from the drop down menu and type: =A2="hot" click on format and format as you like, then click on add.....again select "formula is" and type: =A2="cold" again click on format and format as you like and click OK OK. HTH JG "Clownguy" wrote: in excel, how do i get cell "A1" font to red when cell "A2" says hot, and so on down the list also how do i get cell "A1" font to green when cell "A2" says cold?????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Too many different cell formats | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
How do I print grayscale font in Excel 2003? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |