I need help with a formula

[Bjorn]

I want the color of a cell change depending on the words that are in the
cell. This I have "= IF (D7 = 0, "Not booked", "Reserved")"

 

[Claus Busch]

Hi Björn,

Am Mon, 25 Mar 2013 05:15:47 +0100 schrieb Bjorn:

I want the color of a cell change depending on the words that are in the
cell. This I have "= IF (D7 = 0, "Not booked", "Reserved")"

if this formula is in E7, then:
Select E7 => Conditional formatting => Formula: =E7="Reservd" => and
choose fill color.
Do it again for =E7="Not booked"


Regards
Claus Busch

 

[Bjorn]

It is the font color I want to change. And how do I choose fill color or
font color. I am a amateur. Thanks for the quick answer.

"Claus Busch" skrev i meddelandet
Hi Björn,

Am Mon, 25 Mar 2013 05:15:47 +0100 schrieb Bjorn:

I want the color of a cell change depending on the words that are in the
cell. This I have "= IF (D7 = 0, "Not booked", "Reserved")"

if this formula is in E7, then:
Select E7 => Conditional formatting => Formula: =E7="Reservd" => and
choose fill color.
Do it again for =E7="Not booked"


Regards
Claus Busch

 

[Claus Busch]

Hi Björn,

Am Mon, 25 Mar 2013 13:17:35 +0100 schrieb Bjorn:

It is the font color I want to change. And how do I choose fill color or
font color. I am a amateur. Thanks for the quick answer.

select the cell you want to color => On ribbon Start choose Conditional
Formatting => Formula => Enter your formula => click button "Format" and
choose tab "Font" and there "Color"


Regards
Claus Busch

 

[Bjorn]

Sorry, I'm a real amateur. You must type exactly how it is done. I really
appreciate that you spend time on this. Can I continue with the formula = IF
(D7 = 0, "Not booked", "Reserved"), and how?

"Claus Busch" skrev i meddelandet
Hi Björn,

Am Mon, 25 Mar 2013 13:17:35 +0100 schrieb Bjorn:

It is the font color I want to change. And how do I choose fill color or
font color. I am a amateur. Thanks for the quick answer.

select the cell you want to color => On ribbon Start choose Conditional
Formatting => Formula => Enter your formula => click button "Format" and
choose tab "Font" and there "Color"


Regards
Claus Busch

 

[Claus Busch]

Hi Björn,

Am Mon, 25 Mar 2013 15:08:47 +0100 schrieb Bjorn:

Sorry, I'm a real amateur. You must type exactly how it is done. I really
appreciate that you spend time on this. Can I continue with the formula = IF
(D7 = 0, "Not booked", "Reserved"), and how?

you have to create a formula for every value.
Please look here and download the workbook "Björn":
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!191
Select D7 and look in Conditional Formatting for the formula


Regards
Claus Busch

 

[Bjorn]

Thanks so much! I managed to finish, thanks to you! Do not know how to thank
you, had never succeeded without your help! Thanks again for taking the time
for my problem!

"Claus Busch" skrev i meddelandet
Hi Björn,

Am Mon, 25 Mar 2013 15:08:47 +0100 schrieb Bjorn:

Sorry, I'm a real amateur. You must type exactly how it is done. I really
appreciate that you spend time on this. Can I continue with the formula =
IF
(D7 = 0, "Not booked", "Reserved"), and how?

you have to create a formula for every value.
Please look here and download the workbook "Björn":
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!191
Select D7 and look in Conditional Formatting for the formula


Regards
Claus Busch