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"
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"
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"
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"
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?
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?
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.
