Conditional Formatting
 

I need a cf that color all the rows that meet a condition of a cell.
Example:
Column B as 6 different values in rows. If the value from B1 to B30 is equal
to €œS€�, €œD€� or €œF€�, then all that rows change color to blue.

Thanks in advance for the support

Conditional Formatting
 

Select the range
Go to conditional formatting
Use the formula: =OR($B1="S",$B1="D",$B1="F")
And choose the Blue fill format.

Is that what you wanted?

"henriques" wrote:

I need a cf that color all the rows that meet a condition of a cell.
Example:
Column B as 6 different values in rows. If the value from B1 to B30 is equal
to €œS€�, €œD€� or €œF€�, then all that rows change color to blue.

Thanks in advance for the support

Conditional Formatting
 

That´s grate. Thanks

"~L" escreveu:

Select the range
Go to conditional formatting
Use the formula: =OR($B1="S",$B1="D",$B1="F")
And choose the Blue fill format.

Is that what you wanted?

"henriques" wrote:

I need a cf that color all the rows that meet a condition of a cell.
Example:
Column B as 6 different values in rows. If the value from B1 to B30 is equal
to €œS€�, €œD€� or €œF€�, then all that rows change color to blue.

Thanks in advance for the support