Help with excel

[AntonDVries]

Sup guys, I got a problem.

 

I have a cell (lets say F1) and if F1 is empty, cell G5 (which has text in it) has to disappear, like or the text color to white or you know a better way.

 

Thank you in advance

[vanished]

Do you want it to just appear blank (change text colour) or actually become empty?  Because how you would do that are two different ways (both are pretty easy tho).

[AntonDVries]

11 minutes ago, Ryan_Vickers said:

Do you want it to just appear blank (change text colour) or actually become empty?  Because how you would do that are two different ways (both are pretty easy tho).

Just change the text colour

[LogicalDrm]

Just now, AntonDVries said:

Just change the text colour

Thats done with conditional formatting. I haven't used that into extend where I could assist you without reading online guides on how to.

[vanished]

11 minutes ago, AntonDVries said:

Just change the text colour

Sorry for the slow reply, I got caught up on other things.

 

Select the cell you want to change colour (G5) and go Conditional Formatting  >  New Rule...

then select Use formula to determine which cells to format

click in the text entry field and then click your cell to detect (F5) then finish off =""

Pick the formatting you want with Format... (make it white text).  That way if F5 is empty, G5 will go white, otherwise it will be visible.

[AntonDVries]

40 minutes ago, Ryan_Vickers said:

Sorry for the slow reply, I got caught up on other things.

 

Select the cell you want to change colour (G5) and go Conditional Formatting  >  New Rule...

then select Use formula to determine which cells to format

click in the text entry field and then click your cell to detect (F5) then finish off =""

Pick the formatting you want with Format... (make it white text).  That way if F5 is empty, G5 will go white, otherwise it will be visible.

You. Are. The boss. Thank you so much

[AntonDVries]

47 minutes ago, Ryan_Vickers said:

Sorry for the slow reply, I got caught up on other things.

 

Select the cell you want to change colour (G5) and go Conditional Formatting  >  New Rule...

then select Use formula to determine which cells to format

click in the text entry field and then click your cell to detect (F5) then finish off =""

Pick the formatting you want with Format... (make it white text).  That way if F5 is empty, G5 will go white, otherwise it will be visible.

One more thing, how do I copy paste it to another row, or do I have to manually do that (row for row a new condition)?

[vanished]

10 hours ago, AntonDVries said:

One more thing, how do I copy paste it to another row, or do I have to manually do that (row for row a new condition)?

Ah, yes, that is a bit more troublesome.

Select the cell (G5) and go back into editing (Conditional Formatting  >    Manage Rules...)

Click Edit Rule...

In the textbox, modify the line from =$G$5="" to just =$G5="", removing the $ sign between the G and the 5.

Now, click OK twice and notice the green square in the bottom left of the selected cell (G5).  Grab that and pull it down as far as you want, and it should extend the formatting all the way so that G8 will change based on F8, etc.