[ExcelVBA] Re: Changing cell color based on an value form another cell in Excel 2007

 

Mario,

You can use conditional formatting. Select cell A2. Oh the home tab select conditional formatting. Select New rule. Select use a formula to determine which cells to format. The formula will be typed as =A1="f". Set you formatting options and click apply and ok. Let me know if you have any questions.

--- In ExcelVBA@yahoogroups.com, "clickmario" <clickmario@...> wrote:
>
> Example:
>
> A1 has the value 'F' and I want to make A2 yellow or any other color.
> How can I do that?
>
>
> Thanks
> Mario
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 10

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___