Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is there a way I can have excel shade a cell a color based on tha.
I want to be able to shade a cell in Excel based on that value of that cell;
red if value = 0, green if value = 1. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
is there a way I can have excel shade a cell a color based on tha.
Hi
this can be done without any code using conditional formatting select the cell(s) choose format / conditional formatting choose cell value is choose equal to in the white line type 0 click on the format button go to the patterns tab choose the red click Ok click ADD repeat the steps as above using the new criteria and colour click ok twice. If you'ld prefer a code solution, please feel free to post back Cheers JulieD "Terry" wrote in message ... I want to be able to shade a cell in Excel based on that value of that cell; red if value = 0, green if value = 1. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
is there a way I can have excel shade a cell a color based on tha.
conditional formating
formatconditional formatfollow the wizard -----Original Message----- I want to be able to shade a cell in Excel based on that value of that cell; red if value = 0, green if value = 1. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 noncontiguous cell highlight color=light,light blue. How do I make it darker, or like Excel 2003 ( I'm extremely shade blind-PLZ HELP !! ) | New Users to Excel | |||
Excel 2007 noncontiguous cell highlight color=light,light blue. How do I make it darker, or like Excel 2003 ( I'm extremely shade blind-PLZ HELP !! ) | Excel Discussion (Misc queries) | |||
Is there a formlula to replace cell shade color with another color | Excel Worksheet Functions | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
color/shade cell upon input | Excel Discussion (Misc queries) |