Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Clownguy
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Govind
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
BenjieLop
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
pinmaster
 
Posts: n/a
Default 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
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
Too many different cell formats reb24 Excel Discussion (Misc queries) 4 September 7th 05 03:25 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
How do I print grayscale font in Excel 2003? NKT Excel Discussion (Misc queries) 0 January 26th 05 05:51 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 07:38 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"