Creating a Formula to Format Column automatically?

B

bludovico

Oh, and is it possible to get the data range across the row highlighte
in the same color...i.e. "IF COLUMN D = JOE BLOW, THEN COLOR OF ROW
GREEN"
 
G

Gord Dibben

Select rows to be formatted.

Format>Conditional Formatting>Formula is =$D1="joe blow"

Pick a green color from Format>Pattern and OK

Click Add to add another condition(change formula to read "sally smith") and
format.

Click Add to add a third condition and format.

NOTE the $ sign in $D1

Use an absolute reference to column D to ensure that the conditional
formatting in all columns refers to the value in column D. Otherwise, the
formula will be adjusted in each column, and won't work properly.

Gord Dibben Excel MVP
 
Top