Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
HVN HVN is offline
external usenet poster
 
Posts: 1
Default How do i make a cell change color depending on the value being in.

I'f like to have cells automatically change color depending on what is being
inputted. For example, if 1 is entered, it will be gree, if 0 then red.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default How do i make a cell change color depending on the value being in.

Hi
use 'Format - Conditional format' for this

--
Regards
Frank Kabel
Frankfurt, Germany
"HVN" schrieb im Newsbeitrag
...
I'f like to have cells automatically change color depending on what is
being
inputted. For example, if 1 is entered, it will be gree, if 0 then red.



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
change font color depending on cell value Mickey Excel Worksheet Functions 12 October 1st 08 01:41 AM
can u make a text in a cell to blink , or change it's color? kbee Excel Worksheet Functions 2 February 15th 08 07:40 PM
make cell color change if requirements are met? PMLACC Excel Discussion (Misc queries) 2 July 14th 06 10:01 PM
how do I: click in cell and make it change color? jasonsweeney Excel Programming 7 January 21st 04 09:17 PM
How can I make cell A1 a "Y" or "N" depending upon cell A2's font color? Please help. [email protected] Excel Programming 1 October 16th 03 08:32 PM


All times are GMT +1. The time now is 02:00 AM.

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"