Click on the cell that you wish to have the highlite (Q7).....
Click on Conditional Formatting
Click on Highlite Cell Rules, then More rules
Then click on use a Formula to Determine what cells to format
In the next formula line, put the formula of =IF(R7="",TRUE, FALSE)
In the Formatting box, Select the type of Formatting to use.
That is it.