conditional formating

[bp]

Hello,
I am trying to figure out how to set the color shading of one cell based on
another cell.
so I want to set B1 to green if H1 is 0.
but the conditional formating looks like it works on 1 cell.

any help.
thanks

[JE McGimpsey]

One way:

Set the dropdown(s) and inputbox(es) to read:


CF1: Formula is =H1=0
Format1: <patterns>/<green>



In article <Oj4h4JAYGHA.3760@TK2MSFTNGP02.phx.gbl>, "bp" <x@y.com>
wrote:

> I am trying to figure out how to set the color shading of one cell based on
> another cell.
> so I want to set B1 to green if H1 is 0.
> but the conditional formating looks like it works on 1 cell.

[Peo Sjoblom]

select B1, use formula is

=AND(H1=0,H1<>"")


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"bp" <x@y.com> wrote in message
news:Oj4h4JAYGHA.3760@TK2MSFTNGP02.phx.gbl...
> Hello,
> I am trying to figure out how to set the color shading of one cell based
> on another cell.
> so I want to set B1 to green if H1 is 0.
> but the conditional formating looks like it works on 1 cell.
>
> any help.
> thanks
>
>

[via135]

hi!

choose "formula is" =H1=0

-via135

Hello,
I am trying to figure out how to set the color shading of one cell based on
another cell.
so I want to set B1 to green if H1 is 0.
but the conditional formating looks like it works on 1 cell.

any help.
thanks

[MartinW]

Hi bp,
Here's a very good link from another post.

http://xldynamic.com/source/xld.CF.html#lights