formula help

[vikash]

Hi,

In excel i am trying to find a certain value in a row and on that basis want to change the color of a different row in same sheet.

For eg: whenever Tuesday appear in row 1 color of row 9 should change. What formula to use kindly help.

thanks in advance.

 

[Deepak]

Use need to use Conditional formatting.

 

[Khalid NGO]

Hi Vikash,

How your data looks like?
Can you post a sample with manually filled expected output?

Regards,

 

[Deepak]

Check it

Delete Tuesday and see!

 

[vikash]

Hi,

I have posted the sample file what formula to use to get expected result.

 

[vikash]

Check it

Delete Tuesday and see!

i have days at the top row and i am trying to match it below and on that basis want color in my sheet

 

[vikash]

conditional formatting not helping can you tell me how to use it i am uploading the sample file

Use need to use Conditional formatting.

 

[vikash]

i have days at the top row and i am trying to match it below and on that basis want color in my sheet

 

[Khalid NGO]

So you need row 5 highlighted if row 3 contains Monday
Use conditional formatting as advised above.

Select your range: C5:R5
Go to Conditional Formatting
Formula
=C$3="Monday"

Set the format

Regards,

 

[vikash]

So you need row 5 highlighted if row 3 contains Monday
Use conditional formatting as advised above.

Select your range: C5:R5
Go to Conditional Formatting
Formula
=C$3="Monday"

Set the format

Regards,

its not happening its changing the color for whole selected range

 

[Khalid NGO]

its not happening its changing the color for whole selected range

You may have used:
=$C3="Monday"
instead of:
=C$3="Monday"

See the attached example.
There are 2 highlighted rows
Yellow = dependent on word "Monday" in row # 3
Red = Every 8th column

Check both CF

Regards,

 

[Asheesh]

See the attached

 

[vikash]

You may have used:
=$C3="Monday"
instead of:
=C$3="Monday"

See the attached example.
There are 2 highlighted rows
Yellow = dependent on word "Monday" in row # 3
Red = Every 8th column

Check both CF

Regards,

thanks it worked