Narangba Community

Brisbane Northern Times
Girl saves brother from bed fire
Brisbane Northern Times
THANKS, SIS: Yasmin Daniels, 12, saved her little brother Caleb, 8, and her family when a fire started in their Narangba home last week. ...

and more »

Quest News
Residents left behind in race for high-speed broadband
Quest News
Computer Aid owner Luigi Martin said a band along Boundary Rd had access problems because of its distance from the Narangba and Rothwell exchanges. ...

Parents have donated more than $15 million to keep state schools alive
Courier Mail
Schools such as Narangba Valley State High School make a tidy profit ($616897) from the textbook hire scheme. Instead of parents buying text books every ...

I received this question on the website from Eric regarding conditional formatting:

Hi,

I have the same problem as a few people above but I don't think you got the point of the problem,

In xl2003 if you select A3:A9 and enter conditional format =B3 then select any other cell in the range it will show the conditional format for that cell e.g. A7 will show =B7

In xl2007 after following the same steps it will apply the correct formatting but if you select cell A7 to view the conditional format it will show as =B3. You get the same when checking any cell in range A3:A9.

This makes it near impossible to edit or amend or debug conditional formatting once entered.

Any advice would be appreciated.

Eric.

I started to post my answer and realised that i would be better off writing the whole thing as a blog post with some images to explain.

Hi Eric
i understand the problem and the first answer is that you cannot apply the same sort of logic between the two versions. The new versions (including 2010) manage conditional formatting completely differently, though some of the same concepts apply.
First of all your conditional format formula should be =A3=B3. This will apply the conditional format when the cell in A3 contains the same value as the cell in B3, and this will be relative - eg. when A7=B7 the cell in A7 will have the format applied. So you can see that the relative approach is correct in the conditional format manager in Excel 2007/2010
Second the problem you mentioned. When you look at the relative formula in cell B7 in excel 2003 it showed you just that formula. that is actually harder to debug if you think about it in Excel 2003 than in 2007/2010 as there is no way to see what other cells it also applies to. In Excel 2007/2010 the conditional format manager allows you to see the formula - and the range it is applied to and the little range box (circled in the image below) allows you to view this
The manager allows you to confine the selection to be evaluated to the selected cell(s), the current worksheet or other worksheets in the same workbook. If you then understand the relative / absolute nature of the formula you created then you can debug very successfully. I actually preferred this once I got a hang of using the manager to create sets of conditional formats than can be applied to multiple ranges simultaneously.

I just had to write of some of the awesome things that have been happening around here. This blog has been a little empty of late - and that's partly because of the new business taking up time, the photography business kicking along and just the sheer business of life. But some things have been happening that are connected in ways that are amazing giving me cause to write this article. The photo here was taken Sunday afternoon as a planned shoot for a connected human or a cyborg theme. In this case the two people are totally connected and entangled in the cables and trappings of computer hardware. It was a very interesting concept to put together and shoot and the whole team had a great amount of fun doing it.

Lets start with Sunday - the beginning of the week. For just over a year now our church has been searching for a new pastor after the leaving of the last one. Sunday the search ended with the pastor the search committee and the leadership recommended being accepted by the church. At the conclusion of that meeting we had a BBQ lunch and I was able to share with the church first the little miracle that took place where god miraculously provided the two trays of sliced bread we needed for that lunch. I used that as an example to show how Gods care for us in even the little things is an example of his absolute care for us in all things. Stressing and having anxiety over things in our life is wrong, hurtful and unhealthy.

Monday night home group I was sharing with the guys about this along with some other things from 1 John 2:1-11 and we were talking about how God makes his ways known to us in the most bizarre of circumstances, and how can we know that? By understanding the truth from this little verse, one of my favourites James 1:17 which says in part that God is the father of lights with whom there is no variation or shadow of turning. In other words - he doesn't change his mind, his attitude, his disposition towards us, his morals, his love etc. The actual quote James uses is from a very interesting passage in Numbers 23:19 where Balaam is being asked by Balak to curse the Israelites and he makes this very interesting statement - as a direct word from God:

“God is not a man, that He should lie,
Nor a son of man, that He should repent.
Has He said, and will He not do?
Or has He spoken, and will He not make it good?

Now that's a cool passage - read the whole story - very interesting - it even includes the only recorded instance of an animal talking to a human.

Too often we apply human attributes and traits to God, and that is false. He is not like a man who changes his mind like his dirty shirt. He says and He does.

Fast forward to Friday morning when I am writing this. This week has been about looking for new accommodation as the current place we are living in is going to be sold and we have been given two months to find a new place. As we are looking at places and the clock is ticking inexorably on there is the sense of rising panic - of increasing anxiety - and that is the natural human response. The great thing is finding the peace to pass that whole problem over to God to manage and then resting in the faith and hope that he will manage. if he could supply two trays of sliced bread ahead of time when needed then he can supply a house. Period.

Exciting times!

Sometimes I worry a little too much but then I usually find peace, or an outlet of some sort.

We have had a lot going on lately, well one major thing anyhow. Our lease is coming up for renewal and the owner has decided to sell, so therefore we have not had our lease renewed (probably for the best now that I think of it). With this comes trying to find a place that suits our needs, with a little bit of wants thrown in, and it isn’t hard to find a place that suits our needs, just not our wants. The house we are currently in (for another 6 weeks or less) is big enough that we have room to move and spread out, especially since we work at home, school at home, and live at home.

Hubby needs an office to work in, somewhere he can take the occasional client and staff member, to work. The kids need a space to do their school work and I need a space to set up my creative corner. (My creative corner is where I draw and sew). We want a media room and a yard big enough that the kids are content to stay and play in.  Lots of things to consider.

Apart from this I am laid up from running at the moment due to a sore knee which means I don’t have my usual, and reliable, outlet (and all those feel good endorphins that come with it).

Sometimes I wish things were different, sometimes I am happy with the way they are. Sometimes I wonder how life would have been different if I had one less child, or none at all. If I had gone to uni instead of Tafe (community college), but in the end I am happy with how things have turned out because my life is rich and I have experienced much. I am glad of the friends I have, and wouldn’t change them, for the family I have and the things that have happened (good and bad) in my life. They have all made me who I am.

North Queensland Cowboys
Your Members Player of the Year!
North Queensland Cowboys
Just for voting, Kerrie won Matt's signed match-worn jersey and it's now on its way to Narangba! The Cowboys Membership team received a fantastic number of ...

The longest day of a non-stop campaigner
The Australian
1.50pm: At the Lincom Pacific Equipment plant, a manufacturer of mining machines in Narangba. This is his quickest visit yet: he moves a monster machine by ...

and more »

Little League Offers Big Thrill!
ARL Development
... Alexandra Gusterson (Redcliffe Dolphins), Olivia Hill (Pine Central Holy Spirit), Patricia Jardine (Narangba), Olivia Farrell (Brighton Roosters) and ...

Solverdi Worldwide Limited (SWW) - Financial and Strategic Analysis Review - a ...
Live-PR.com (press release)
The company owns and operates a biodiesel plant at Narangba, North of Brisbane. In 2008, it has sold over 200 million litres of biodiesel. ...

Drag race hotshot in drug trial
Ninemsn
A committal hearing in Brisbane Magistrates Court on Monday and Tuesday was told that Stevens, 45, produced ecstasy and cannabis at his Narangba home ...

Drag race hotshot in drug trial
Sydney Morning Herald
A committal hearing in Brisbane Magistrates Court on Monday and Tuesday was told that Stevens, 45, produced ecstasy and cannabis at his Narangba home ...
Former Australia drag racing champion Brett Stevens to stand trial on serious ...Courier Mail

all 13 news articles »

Former Australia drag racing champion Brett Stevens to stand trial on serious ...
Courier Mail
The Brisbane Magistrates Court heard further evidence Brett Raymond Stevens, of Narangba, north of Brisbane, threatened to kill Martin "Marty" Kirkby if he ...
Drag race hotshot in drug trialBrisbane Times

all 13 news articles »

Quest News
Maroon girls beat nation
Quest News
The squad was managed by Julie Bowman, from Narangba, who filled the same role when the state side won silver in Canberra last year. ...

and more »

Brisbane Times
Election choices no problem for young voter/candidate, Wyatt
Brisbane Times
20-year-old LNP candidate for Longman Wyatt Roy waves to constituents on Oakey Flat Road in Narangba. Photo: Michelle Smith Voting in his first federal ...

and more »

Westerner
Action group gains momentum
Westerner
... Ratepayers Action Group Moreton Bay, which is looking to form new branches at Closeburn, Woodford, Bray Park, Deception Bay, Bribie Island and Narangba. ...

Brisbane Northern Times
Kahlia sings her way to success
Brisbane Northern Times
AMAZED BY AWARD: Narangba all-sibling band Freak Morice's lead singer Kahlia Ferguson wrote the song that took out the secondary school award at the Q Song ...

and more »

AUSTRALIA'S CSR TO SELL US$23MLN RESIDENTIAL SITE TO STOCKLAND
Trading Markets (press release)
Australian building products and sugar producer CSR Ltd (ASX:CSR) says it will sell a residential site at Narangba, north of Brisbane, to Stockland ...

Caboolture Shire Herald
Dominique stars for maroon girls
Caboolture Shire Herald
The squad was managed by Julie Bowman, of Narangba, who filled the same role when the state side won silver in Canberra last year. ...

Brisbane Northern Times
Top gig turns Freak show
Brisbane Northern Times
THERE has been no time for Narangba-based band Freak Morice to rest on their laurels after winning the chance to support Powderfinger and Jet at the ...