I want to chage a whole rows text color based on single cell valu.

T

thediamondfam

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

Trevor Shuttleworth

You can do this with Conditional Formatting. Other than that, I think
you'll need a macro.

Regards

Trevor
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tracked changes by multiple people modified to one 0
Excel does not accept text format! 0
Change row colors based on a cell value 1
shading a cell or group of cells based on value 5
Function for summing or counting cells based on a specified fill color 3
conditional format of entire row based on a single cell in row 7
add value of cells based on the formatted fill color 3
Is there a way to change the color 3

Top