is there a way I can have excel shade a cell a color based on tha.

T

Terry

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.
 
J

JulieD

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I convert shading to highlighting for specific colors 8
Excel does not accept text format! 0
Select text of a particular shading color (VBA macro) 5
Match table shading (color) to Visio color/Transparency 1
Remove Hyperlinks Without Changing background shading 14
table shading prints differently on different pages 0
Use BeforeDoubleClick to place 1 or 4 character in a cell 1
active combobox - possible to configure as display value andcoordinate value? 3

Top