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
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
One way:
Set the dropdown(s) and inputbox(es) to read:
CF1: Formula is =H1=0
Format1: <patterns>/<green>
In article <[email protected]>, "bp" <[email protected]>
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.
select B1, use formula is
=AND(H1=0,H1<>"")
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"bp" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
hi!
choose "formula is" =H1=0
-via135
Originally Posted by bp
Hi bp,
Here's a very good link from another post.
http://xldynamic.com/source/xld.CF.html#lights
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks