select cell D2
use FormatConditional formatting
select Formula is and type in =G2=some value
then set your format

Instead of G2 *equals* some value, you can use < , = ,<=, etc


"D4137" wrote:

How do I set the conditional formating for cell D2 based on the value in cell
G2?