Conditional formatting based for multiple columns 1

[ovs8]

I have a table with dozens of columns. I want to conditionally format this table comparing each column to it's 1st row's value. Is there a way to do that?

Thanks a lot,
oleg

 

[xlhelp]

Pardon me for asking. Have you tried?

Member AAA - Abolish Abused Abbreviations

 

[SkipVought]

Hi,

Select ALL the cells you want to format UNDER the first rows headings.

Lets assume that its B10 to Z999, with heading values in row 9

Open the CF Wizard

select Formula is:

In the text box: click on B10

Hit F4 until the reference is relative

enter whatever operator you need in your criteria

click on B9

Hit F4 until the reference is absolute to the row & relative to the column

should be something like...
[tt]
=B10=B$9
[/tt]
Select your formatting

VOLA!

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}