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

T

TicklePig

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
 
E

Eddie O

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.
 
G

Gary''s Student

Yes. Use conditional formatting

Format > Conditional Formatting and select Formula is and enter

=(A1=1) and then select your format
 
G

Gord Dibben

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
 
D

David McRitchie

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/excel.htm#tutorials
 
Top