Can I modify cell attributes (font,color etc.) based on function .

For a simple example, if A1=1 then the font color of A2 = 'blue'. Are there,
and if so, can I access and mofiy the attributes of a cell based on a boolean
result of a function in that or another cell?

Also, can I do this without Macro VB scripting/programming?

I have been a programmer for many years and the few times I have opened up
the Macro/VB editor from Excel, Word, etc. I was befuddled. I can write VB
script/code and have done it many times just not through the 'Macro' options
of an MS application. I know, it says a lot; I either suck at programming, MS
has an unintuative interface, or I have ADHD. All or a combination of the
above could be true but that is not my question.

Can I modify cell attributes (font,color etc.) based on function result in
an Excel worksheet?

Thanks in advance

Not sure if this can be done with a formula, but it can be done with
conditional formatting (Format / Conditional Formatting). By default the
condition is based on the cell value in the cell itself (the one you'll be
formatting), but if you change the condition from Cell Value Is to "Formula
Is," you can refer to a value in a different cell in order to format "this"
cell.
Hope that helps.

"TicklePig" wrote:

> For a simple example, if A1=1 then the font color of A2 = 'blue'. Are there,
> and if so, can I access and mofiy the attributes of a cell based on a boolean
> result of a function in that or another cell?
>
> Also, can I do this without Macro VB scripting/programming?
>
> I have been a programmer for many years and the few times I have opened up
> the Macro/VB editor from Excel, Word, etc. I was befuddled. I can write VB
> script/code and have done it many times just not through the 'Macro' options
> of an MS application. I know, it says a lot; I either suck at programming, MS
> has an unintuative interface, or I have ADHD. All or a combination of the
> above could be true but that is not my question.
>
> Can I modify cell attributes (font,color etc.) based on function result in
> an Excel worksheet?
>
> Thanks in advance

Yes. Use conditional formatting

Format > Conditional Formatting and select Formula is and enter

=(A1=1) and then select your format
--
Gary''s Student


"TicklePig" wrote:

> For a simple example, if A1=1 then the font color of A2 = 'blue'. Are there,
> and if so, can I access and mofiy the attributes of a cell based on a boolean
> result of a function in that or another cell?
>
> Also, can I do this without Macro VB scripting/programming?
>
> I have been a programmer for many years and the few times I have opened up
> the Macro/VB editor from Excel, Word, etc. I was befuddled. I can write VB
> script/code and have done it many times just not through the 'Macro' options
> of an MS application. I know, it says a lot; I either suck at programming, MS
> has an unintuative interface, or I have ADHD. All or a combination of the
> above could be true but that is not my question.
>
> Can I modify cell attributes (font,color etc.) based on function result in
> an Excel worksheet?
>
> Thanks in advance

Pig

Use Format>Conditional Formatting

Select A2 and Format>CF>Formula is: =$A$1=1

Pick a format and OK your way out.

Note: you can have up to 3 conditions(4 if you count default) per cell.


Gord Dibben Excel MVP

On Mon, 28 Nov 2005 09:31:20 -0800, TicklePig
<[email protected]> wrote:

>For a simple example, if A1=1 then the font color of A2 = 'blue'. Are there,
>and if so, can I access and mofiy the attributes of a cell based on a boolean
>result of a function in that or another cell?
>
>Also, can I do this without Macro VB scripting/programming?
>
>I have been a programmer for many years and the few times I have opened up
>the Macro/VB editor from Excel, Word, etc. I was befuddled. I can write VB
>script/code and have done it many times just not through the 'Macro' options
>of an MS application. I know, it says a lot; I either suck at programming, MS
>has an unintuative interface, or I have ADHD. All or a combination of the
>above could be true but that is not my question.
>
>Can I modify cell attributes (font,color etc.) based on function result in
>an Excel worksheet?
>
>Thanks in advance

If you did not get the answer you were looking for, I would think it more likely that
the other cell is on the same row in which case it might be more like
=$A1=1 note the row number is not absolute
and check with http://www.mvps.org/dmcritchie/excel/condfmt.htm
to read about how your usage relates to the active cell and the selection.
And I would also suggest the Conditional Formatting video file (flash 8) at datapig
that you can find a link to at http://www.mvps.org/dmcritchie/excel....htm#tutorials
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gord Dibben" <gorddibbATshawDOTca> wrote in message news:[email protected]...
> Pig
>
> Use Format>Conditional Formatting
>
> Select A2 and Format>CF>Formula is: =$A$1=1
>
> Pick a format and OK your way out.
>
> Note: you can have up to 3 conditions(4 if you count default) per cell.
>
>
> Gord Dibben Excel MVP
>
> On Mon, 28 Nov 2005 09:31:20 -0800, TicklePig
> <[email protected]> wrote:
>
> >For a simple example, if A1=1 then the font color of A2 = 'blue'. Are there,
> >and if so, can I access and mofiy the attributes of a cell based on a boolean
> >result of a function in that or another cell?
> >
> >Also, can I do this without Macro VB scripting/programming?
> >
> >I have been a programmer for many years and the few times I have opened up
> >the Macro/VB editor from Excel, Word, etc. I was befuddled. I can write VB
> >script/code and have done it many times just not through the 'Macro' options
> >of an MS application. I know, it says a lot; I either suck at programming, MS
> >has an unintuative interface, or I have ADHD. All or a combination of the
> >above could be true but that is not my question.
> >
> >Can I modify cell attributes (font,color etc.) based on function result in
> >an Excel worksheet?
> >
> >Thanks in advance
>