a local taxes 2013 she two rooms in this video
Enrique doing a little bit ish conditional formatting
on the should form making so ish wanna play along
shuttling murder videos and analysis above site and elections 2013 dv6t
and to connect up
and
sometime access to electricity
shearer password password
okay so we a no interest in this the moment interested
shoes interested
in a.m. member phone charger securities so
yah
so
he says waiting for something to happen gnashing inside
right okay but a.m.
his deal we've got the show July we've got the
the concept of having the dates along the top tier
and then within the schedule a a.m.
Sunday's correspond to certain stays in certain rooms and room 502
them all we can say is from shifting from October
to the 29 shots of Jameson
who separates you staying in room five ish floor and room 505
to this interesting so just obviously I I was
stand tree date willy nilly but the year
you know maybe he's got on our kids you know he's going in
two hours bigamist auto but whatever he's there in
sure your arms as thing is where you set the shed
dropped his to it looks up the
value indeed bookings expose she simply us a question on the 18th October
in room four side is there record if there is an
is actually displaying -1 make on C hysteresis displaying the names
so would have done is a added conditional formatting
from this row all the way to the end
haven't done on the first ok some show you what I've done
a.m. it's not perfect as you can see
but Eric the nouns can say how I did
that and to to be so much as we can use condition for mine
for solace to listen to lay up to you disperse controllers one
to show you ribbon and when I did was
all these text books and names from Texas 0 one
text to sorry for all the way up I clicked on
text books artist format: I went to conditional formatting
and need to do two things first money to say
ish the value in the text box is equal to -1
to hide it so you took a neutral finished my actually hiding
arm making the colors to text shames
background sexist so we say is
showed value is equal to you -1
now this expressions as check reader
then gonna say the
background should be blank Andy
tech should be blacks first okay and apply
to see it disappear so
then use a logically okay to start another rule say
show values in is not see to
-1 will say
the backcolor combi this
pale past orange
be complete if tensions and the text me that color press OK
Press Troy open the champagne
and it doesn't work why doesn't work no idea
some reason if it's equal to -1 it works is Nick
-1 it doesn't work thank you so much access
actually going to is gonna do school work around
I'm and yeah us
are gonna try I was going slow were crowned sure you know
lies and ice and pick a new rule work round 2i would explain is just a wave
achieving something an indirect way of achieving something
because the most simple direct way doesn't seem to work
so the woman eat attendees you need to evaluate dish
text books and minus ones and number
and tamer in isn't so long is a mosque
the Moss access if this text books doesn't contain
numeric value make the background color is orange
and the text back we do that by going
to expression is clicking on the
glitches me say not is numeric
and we have to choose this particular text books which is text 0
txt 0 make sure you've got the
open/close square brackets round nine quotation marks
so best conditions valuating the text books
is numeric we will
changed back from college
orange you change the
short from a black apply for
and lo and behold that works so there you go than 10 -1 thing didn't work
where okay so for Supply
not just on that press OK go to Sean
view now
it's much easier to see okay right the bomb
knowingly in his room to go mister jameson
no one else and every now and again -1 pops up
for no apparent reason no idea wanna
have to worry about it too much and say a
us how to add conditional formatting in the next video
I am showing you how you can click on disgraced
and bring up the relevant the related booking russians
to thank you for watching