change text color based on adjacent cell text color

As I understand you want all formats in One row to depend on the value in One Column?

Try this:
Select menu: Format>Conditional formatting...
Under Condition 1: change from 'Cell Value Is' to 'Formula Is' =$B1
and select your format
Done

Now use the Format painter button to format all cell in you example:
...........Col A...ColB...Col C
Row 1 data1 data2 data3
Row 2 data1 data2 data3
Row 3 data1 data2 data3


Ola Sandstrom

Thank you for your help.

We are on the right track, but now i get this



...........Col A...ColB...Col C
Row 1 data1 data2 data3
Row 2 data1 data2 data3
Row 3 data1 data2 data3


what i need is this

...........Col A...ColB...Col C
Row 1 data1 data2 data3
Row 2 data1 data2 data3
Row 3 data1 data2 data3


The text color for column for a and c will not be the same for the entire coulmn.
Insted I need the text color for an entire row to match the text color in column b for each individual row.


In other words, If the text in b7 is red then the text in a7 and c7 should also be red but b9 is green so I need the text in a9 and c9 to also be green.


Thanks for any help you can give.

What is the condition for Column B to be formatted?

Originally Posted by matthewst

Thank you for your help.

We are on the right track, but now i get this



...........Col A...ColB...Col C
Row 1 data1 data2 data3
Row 2 data1 data2 data3
Row 3 data1 data2 data3


what i need is this

...........Col A...ColB...Col C
Row 1 data1 data2 data3
Row 2 data1 data2 data3
Row 3 data1 data2 data3


The text color for column for a and c will not be the same for the entire coulmn.
Insted I need the text color for an entire row to match the text color in column b for each individual row.


In other words, If the text in b7 is red then the text in a7 and c7 should also be red but b9 is green so I need the text in a9 and c9 to also be green.


Thanks for any help you can give.

condidtion 1 cell value is less than =TODAY()
AABBCCDD


condidtion 2 cell value is less than or equal to =TODAY()+90
AABBCCDD



condidtion 3 cell value is less than or equal to =TODAY()+180
AABBCCDD


I need the cells in the rows where column b is red to all be red.
likewise with the green and orange

Try the following...

1) Select your data

2) Format > Conditional Formatting > Formula Is

Condition 1:

=($B1<>"")*($B1<TODAY())

...and choose your formatting.

Condition 2:

=($B1<>"")*($B1<=TODAY()+90)

...and choose your formatting.

Condition 3:

=($B1<>"")*($B1<=TODAY()+180)

...and choose your formatting.

Hope this helps!

Originally Posted by matthewst

condidtion 1 cell value is less than =TODAY()
AABBCCDD


condidtion 2 cell value is less than or equal to =TODAY()+90
AABBCCDD



condidtion 3 cell value is less than or equal to =TODAY()+180
AABBCCDD


I need the cells in the rows where column b is red to all be red.
likewise with the green and orange

You are a genius!!!!!!!!!!!