I need help with a formula

  • Thread starter Thread starter Bjorn
  • Start date Start date
B

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")"
 
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")"
Click to expand...

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
 
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")"
Click to expand...

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
 
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.
Click to expand...

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
 
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.
Click to expand...

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
 
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?
Click to expand...

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
 
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?
Click to expand...

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
 
Back
Top