Conditional Formatting Question

Hi Guys

So i got a small problem here i got an excel sheet and i've with the following as header names

Time VALID_FROM USER_NO USERNAME COUNTRY LANGUAGE_ID CAMPAIGN_LANGUAGE CURRENCY_ID DEFAULT_CURRENCY_FOR_COUNTRY GEOIP_COUNTRY BonusCampaign Balance

if country is equal to FI and language is equal to En i want the whole row to turn a colour; i went on conditional formatting and entered this into the rule:

=AND($F$3="en", $E$3="Fi")

In the applied to section i entered:

=$3:$3

(as im dealing with row 3)

This works fine.

My problem is that i want the rule to be carried down row to row; meaning the row below i want:

=AND($F$4="en", $E$4="Fi")

=$4:$4

And so on. Is there a way i can do this without doing it manually? As ive got over 1000 rows!

Do this highlights all the cells i highlight with the painter based on the first condition

No i mean it doesnt work!

If i do this; then if row 3 equals the conditions, then all the rows i select with the painter will only change colour based on the data in row 3; this isnt what i want. I need every row to be treated individually.

Hi,

Select the entire Range first, then do Conditional format , In formula remove those $ symbols @ row index part.

thanks mmmarks

AKA

Select all the rows from 3 down and use the CF formula

=AND($F3="en",$E3="Fi")

Originally Posted by aborg88

thanks mmmarks

AKA

Select all the rows from 3 down and use the CF formula

=AND($F3="en",$E3="Fi")

Thanks for feedback