How to change the colour of a cell(s) based on cell value

A

Artful Dodger

Hello guys,
I am stuck on this rather simple problem. Could not find any hel
searching Google.
I want to change the colour of a cell to green if the vallue is = Tru
and to red if it is False.
I have tried to use the Conditional Formating but without joy.

Thank you
 
J

JulieD

Hi

select the cells
choose format / conditional formatting
choose
cell value is
equal to
and type
true
click on format button choose green click OK

click ADD
choose
cell value is
equal to
and type
false
click on format button choose red click OK
click Ok again

if this doesn't work, how are you generating the true & false statements?

Regards
JulieD
 
J

JE McGimpsey

One way, using CF:

Select your cell. Choose Data/Conditional Formatting and use the
dropdowns and textbox to enter

Cell value is equal to FALSE

Click the Format button and choose red from the Patterns tab. Click OK.

Click the Add button. Enter

Cell value is equal to TRUE

and choose green from the Format/Pattern tab.


If the cell will always have either TRUE or FALSE, you can shade the
cell green with the color palette and forget about the second
conditional format.
 
A

Artful Dodger

Thank you for the prompt reply. Weird. It did not work when I tried it
but now is OK.
I am testing multiple cells using logic. Comparing cells A1, B1, C1 t
D1, E1, F1.

Thank you guys. I should have tested it few times before posting thi
thread
 
A

AT

Artful

If you want to go beyond the limitations of Excel, i.e. beyond the 3
conditional formats allowed, then use Excel with Analysis Services. Refer to
our website www.o2olap.com to see an example in reports. You can even color
you data based on values within the cube.

AT
www.o2olap.com
 
D

David McRitchie

I find it a lot better to always use formulas and then it is easier
to work with C.F. The main reason for inconsistent results is
not paying attention the address of the active cell when
entering a formula. The formula you write is relative to the
active cell. The cells that get colored are among those cells
in the selection when you enter your C.F. formulas.
http://www.mvps.org/dmcritchie/excel/condfmt.htm
 
D

David McRitchie

Didn't see any hint of the poster needing more than the
3 conditions allowed in Conditional Formatting. There is
so much free help available in these newsgroup including:

Extended Conditional Formatter «Excel addin«, Bob Phillips
& Frank Kabel, makes it possible to enter up to 50 conditions
with the same entry type panels as builtin Conditional Formatting.
Note this is Beta software (testing not production).
http://www.xldynamic.com/source/xld.CFPlus.Download.html

on the other hand for your site, I think it is important
that people be able to find the price of your software without going
through hoops to find out. I presume one finds out after downloading
or after the 30 day trial.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

AT said:
Artful

If you want to go beyond the limitations of Excel, i.e. beyond the 3
conditional formats allowed, then use Excel with Analysis Services. Refer to
our website www.o2olap.com to see an example in reports. You can even color
you data based on values within the cube.

AT
www.o2olap.com
Click to expand...
 
Top