Final answer:
To compare the contents of cells G5 and G20 using the Formula Bar, use the formula =G5=G20. Apply bold formatting to the cell that contains a value instead of a formula using conditional formatting.
Step-by-step explanation:
To compare the contents of cell G5 and cell G20 using the Formula Bar, you can simply type the following formula in the Formula Bar: =G5=G20
This formula compares the values in cell G5 and G20 and returns TRUE if they are equal or FALSE if they are not.
To apply bold formatting to the cell that contains a value instead of a formula, you can use conditional formatting. Select the cell range you want to apply the formatting to, go to the 'Home' tab, click on 'Conditional Formatting', and choose 'New Rule'. Then, select 'Format only cells that contain' and choose 'Blanks' from the dropdown. Finally, click on 'Format' and apply bold formatting to the cells.