Changing cell colour according to data in another cell

Hi,

I sincerely apologise if I am duplicating anything on this forum, but I've searched for hours and haven't found anything that works on my Excel sheet yet.

I'm a relatively new user to Excel (and ready to throw my laptop through the window with frustration) - so any help is so gratefully received! I know it will be the simplest of simple for some people on here.

Basically, I'm making a document for assessment purposes of students I have. There are different targets they need to achieve in one column, then directly next to that on the right is another column with the value 1 or 0, depending if they've met the criteria (1 for yes, 0 for no).

I've got the cell with the value to change colour (yellow if the value is 0), but I don't know how to get the cell with the actual target to change colour too.

Example:

If a target is met (target is typed into cell B5), I want B5 AND C5 cells to change to grey.
If this target is not met, I want B5 AND C5 cells to change to yellow.
If there is no value entered into C5, I want B5 AND C5 to stay white.

I know it's something to do with the conditional formatting, but I can't figure exactly what to type. It's driving me crazy!

Any help will be met with a massive THANK YOU!

THANK YOU!!!!!!!!!! You have saved me hours and hours and hours

It works perfectly!

Just one last question - how do I apply this to more cells? Surely there's an easier way doing it without having to type in to every cell (have about 200 cells to do this with!). Can't find a way to 'copy&paste) it in.

I don't understand what it's doing. I've done B5 and C5 with the formula. When I copy these cells, then highlight the cells I want it to copy to, click paste special -> formulas.... it only pastes the stuff (the words, as opposed to the formula) typed into the cell, even when I've definitely made sure I've not clicked 'All'. I don't understand?!?

I meant formats, sorry. Tried it with formats. Similar applies.

I copy&paste -> special formats. Result is it copies only one of the two formulas I put it - e.g. it changes grey when I type 1, but not yellow when I type 0.

One of the CFs is fine - the cell references are of the new cell (perfect, not the one I pasted it from). The issue is that there's only one of the formulas, not the second. Just doing it one by one now.

Thanks for your help