Manipulation cell colours

[mas_lerdanch]

Is it possible to create a formula that looks at a cell (say A20) and if TRUE changes the colour of A22 to green if false to red?

Long shot...

 

[TheNoocH]

conditional formatting would do just that...

Excel Workbook
	A	B
20	TRUE	FALSE
21	*	*
22	*	*
23	*	*
Sheet1

under conditional formatting you would set up these rules under cell A22...

formula is =A20=FALSE (change fill to red)
formula is =A20=TRUE (change fill to green)

then if you copy that cell to B22 it will copy the formatting as well...

 

[mas_lerdanch]

Struggling with excel2007 a little ...

 

[TheNoocH]

First have your cursor in cell A22

if you are on the home tab...there is a contiditional formatting button (under the styles section)...click on new rule...select use a formula to determine which cells to format...

under the format values where this formula is true....type in =A20=TRUE
click on format button...select the green color...

do the same thing but under the new rule type in =A20=FALSE...click on format button...select the red color...

 

[mas_lerdanch]

Hey thanks - got that working for the value TRUE what is the value is different text like yes? Can you apply the same to row values such as B6 goes Green when R6 is equal to Yes?

 

[TheNoocH]

yup...just do the same thing but if it's a text value like YES then just enclose it in quotes...

eg =R6="Yes"

 

[mas_lerdanch]

Got it sussed changing Green (Yes) to Red (no) great when you know how - Thanks for all your help!
Mas

 

[mas_lerdanch]

Hey how should I word the formula for two different values for instance
=AM6="Yes" or "Couple" or should I just repeat the formula... silly question really

 

[TheNoocH]

you could use seperate rules or try something like this...
=OR(A1="Yes",A1="Couple")

 

[mas_lerdanch]

Thanks NooCH ;-D works a treat!