1
00:00:00,410 --> 00:00:03,480
a local taxes 2013 she two rooms in this video

2
00:00:03,480 --> 00:00:07,378
Enrique doing a little bit ish conditional formatting

3
00:00:07,378 --> 00:00:11,320
on the should form making so ish wanna play along

4
00:00:11,320 --> 00:00:17,170
shuttling murder videos and analysis above site and elections 2013 dv6t

5
00:00:17,170 --> 00:00:24,170
and to connect up

6
00:00:27,010 --> 00:00:29,480
and

7
00:00:29,480 --> 00:00:35,100
sometime access to electricity

8
00:00:35,100 --> 00:00:39,450
shearer password password

9
00:00:39,450 --> 00:00:43,800
okay so we a no interest in this the moment interested

10
00:00:43,799 --> 00:00:47,689
shoes interested

11
00:00:47,689 --> 00:00:54,689
in a.m. member phone charger securities so

12
00:00:54,869 --> 00:00:59,119
yah

13
00:00:59,119 --> 00:01:02,669
so

14
00:01:02,670 --> 00:01:07,849
he says waiting for something to happen gnashing inside

15
00:01:07,849 --> 00:01:11,199
right okay but a.m.

16
00:01:11,200 --> 00:01:14,799
his deal we've got the show July we've got the

17
00:01:14,799 --> 00:01:17,868
the concept of having the dates along the top tier

18
00:01:17,868 --> 00:01:21,849
and then within the schedule a a.m.

19
00:01:21,849 --> 00:01:26,689
Sunday's correspond to certain stays in certain rooms and room 502

20
00:01:26,689 --> 00:01:31,069
them all we can say is from shifting from October

21
00:01:31,069 --> 00:01:34,239
to the 29 shots of Jameson

22
00:01:34,239 --> 00:01:38,289
who separates you staying in room five ish floor and room 505

23
00:01:38,289 --> 00:01:41,719
to this interesting so just obviously I I was

24
00:01:41,719 --> 00:01:45,090
stand tree date willy nilly but the year

25
00:01:45,090 --> 00:01:49,380
you know maybe he's got on our kids you know he's going in

26
00:01:49,379 --> 00:01:53,149
two hours bigamist auto but whatever he's there in

27
00:01:53,149 --> 00:01:56,560
sure your arms as thing is where you set the shed

28
00:01:56,560 --> 00:01:59,810
dropped his to it looks up the

29
00:01:59,810 --> 00:02:05,228
value indeed bookings expose she simply us a question on the 18th October

30
00:02:05,228 --> 00:02:08,459
in room four side is there record if there is an

31
00:02:08,459 --> 00:02:13,020
is actually displaying -1 make on C hysteresis displaying the names

32
00:02:13,020 --> 00:02:16,290
so would have done is a added conditional formatting

33
00:02:16,289 --> 00:02:19,469
from this row all the way to the end

34
00:02:19,469 --> 00:02:22,669
haven't done on the first ok some show you what I've done

35
00:02:22,669 --> 00:02:27,049
a.m. it's not perfect as you can see

36
00:02:27,050 --> 00:02:31,330
but Eric the nouns can say how I did

37
00:02:31,330 --> 00:02:35,480
that and to to be so much as we can use condition for mine

38
00:02:35,479 --> 00:02:38,869
for solace to listen to lay up to you disperse controllers one

39
00:02:38,870 --> 00:02:42,150
to show you ribbon and when I did was

40
00:02:42,150 --> 00:02:45,400
all these text books and names from Texas 0 one

41
00:02:45,400 --> 00:02:49,480
text to sorry for all the way up I clicked on

42
00:02:49,479 --> 00:02:53,439
text books artist format: I went to conditional formatting

43
00:02:53,439 --> 00:02:57,030
and need to do two things first money to say

44
00:02:57,030 --> 00:03:02,379
ish the value in the text box is equal to -1

45
00:03:02,379 --> 00:03:07,099
to hide it so you took a neutral finished my actually hiding

46
00:03:07,099 --> 00:03:10,949
arm making the colors to text shames

47
00:03:10,949 --> 00:03:14,179
background sexist so we say is

48
00:03:14,180 --> 00:03:17,740
showed value is equal to you -1

49
00:03:17,740 --> 00:03:21,290
now this expressions as check reader

50
00:03:21,289 --> 00:03:24,349
then gonna say the

51
00:03:24,349 --> 00:03:27,939
background should be blank Andy

52
00:03:27,939 --> 00:03:31,099
tech should be blacks first okay and apply

53
00:03:31,099 --> 00:03:34,310
to see it disappear so

54
00:03:34,310 --> 00:03:37,659
then use a logically okay to start another rule say

55
00:03:37,659 --> 00:03:40,799
show values in is not see to

56
00:03:40,800 --> 00:03:45,990
-1 will say

57
00:03:45,990 --> 00:03:49,090
the backcolor combi this

58
00:03:49,090 --> 00:03:52,090
pale past orange

59
00:03:52,090 --> 00:03:56,950
be complete if tensions and the text me that color press OK

60
00:03:56,949 --> 00:04:00,280
Press Troy open the champagne

61
00:04:00,280 --> 00:04:03,490
and it doesn't work why doesn't work no idea

62
00:04:03,490 --> 00:04:06,659
some reason if it's equal to -1 it works is Nick

63
00:04:06,659 --> 00:04:10,240
-1 it doesn't work thank you so much access

64
00:04:10,240 --> 00:04:13,300
actually going to is gonna do school work around

65
00:04:13,300 --> 00:04:16,389
I'm and yeah us

66
00:04:16,389 --> 00:04:20,139
are gonna try I was going slow were crowned sure you know

67
00:04:20,139 --> 00:04:24,918
lies and ice and pick a new rule work round 2i would explain is just a wave

68
00:04:24,918 --> 00:04:28,049
achieving something an indirect way of achieving something

69
00:04:28,050 --> 00:04:31,530
because the most simple direct way doesn't seem to work

70
00:04:31,529 --> 00:04:35,659
so the woman eat attendees you need to evaluate dish

71
00:04:35,660 --> 00:04:39,960
text books and minus ones and number

72
00:04:39,959 --> 00:04:43,549
and tamer in isn't so long is a mosque

73
00:04:43,550 --> 00:04:47,740
the Moss access if this text books doesn't contain

74
00:04:47,740 --> 00:04:51,160
numeric value make the background color is orange

75
00:04:51,160 --> 00:04:54,180
and the text back we do that by going

76
00:04:54,180 --> 00:04:57,970
to expression is clicking on the

77
00:04:57,970 --> 00:05:01,260
glitches me say not is numeric

78
00:05:01,259 --> 00:05:04,849
and we have to choose this particular text books which is text 0

79
00:05:04,850 --> 00:05:11,250
txt 0 make sure you've got the

80
00:05:11,250 --> 00:05:15,800
open/close square brackets round nine quotation marks

81
00:05:15,800 --> 00:05:20,139
so best conditions valuating the text books

82
00:05:20,139 --> 00:05:23,280
is numeric we will

83
00:05:23,279 --> 00:05:26,759
changed back from college

84
00:05:26,759 --> 00:05:30,889
orange you change the

85
00:05:30,889 --> 00:05:35,129
short from a black apply for

86
00:05:35,129 --> 00:05:40,439
and lo and behold that works so there you go than 10 -1 thing didn't work

87
00:05:40,439 --> 00:05:43,610
where okay so for Supply

88
00:05:43,610 --> 00:05:47,280
not just on that press OK go to Sean

89
00:05:47,279 --> 00:05:51,359
view now

90
00:05:51,360 --> 00:05:54,790
it's much easier to see okay right the bomb

91
00:05:54,790 --> 00:05:59,199
knowingly in his room to go mister jameson

92
00:05:59,199 --> 00:06:03,009
no one else and every now and again -1 pops up

93
00:06:03,009 --> 00:06:07,110
for no apparent reason no idea wanna

94
00:06:07,110 --> 00:06:10,210
have to worry about it too much and say a

95
00:06:10,209 --> 00:06:13,310
us how to add conditional formatting in the next video

96
00:06:13,310 --> 00:06:17,040
I am showing you how you can click on disgraced

97
00:06:17,040 --> 00:06:21,139
and bring up the relevant the related booking russians

98
00:06:21,139 --> 00:06:21,790
to thank you for watching