Highlight Cell Based on another Cell's Value

[dkgolfer39]

Hello,

I'm trying to highlight a cell based on what I've inputted in another cell. My condition is as follows:

Cell G30 : (?)
Cell H30 : A forumla

I would like H30 to highlight red if G30 has (?) inputted. Once I've changed G30 to say 4, I would like H30 to go back to unhighlighted.

I need the forumal in H30 to stay working throughout though.

Thank you for the help!

[Legs]

This is something i have been playing around with but have had no luck. Would love it if someone could help.

[daddylonglegs]

Try using conditional formatting - do you know how to use that?

Select H30 and use this formula in CF

=G30="?"

format as required