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