Select row or cells to Format.

Then FormatCellsFormula is =$A1=1

Pick a font color from the Format dialog and OK your way out.

NOTE: the dollar sign($) in $A1 must be entered.

$A1=1 would of course be adjusted to your preferred cell and value.


Gord Dibben Excel MVP

On Tue, 11 Jan 2005 15:03:03 -0800, "thediamondfam"
wrote:

I am trying to change the text color of multiple cells based on the value of
one cell