I am trying to change the text color of multiple cells based on the value of one cell
T thediamondfam Jan 11, 2005 #1 I am trying to change the text color of multiple cells based on the value of one cell
T Trevor Shuttleworth Jan 11, 2005 #2 You can do this with Conditional Formatting. Other than that, I think you'll need a macro. Regards Trevor
You can do this with Conditional Formatting. Other than that, I think you'll need a macro. Regards Trevor
G Gord Dibben Jan 12, 2005 #3 Select row or cells to Format. Then Format>Cells>Formula 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
Select row or cells to Format. Then Format>Cells>Formula 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
