• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

formula help

V

vikash

New Member
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.
 
Hi Vikash,

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

Regards,
 
Hi,

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

Attachments

  • sample file.xlsx
    8.3 KB · Views: 2
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,
 
Khalid NGO said:
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,
Click to expand...
its not happening its changing the color for whole selected range
 
vikash said:
its not happening its changing the color for whole selected range
Click to expand...
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,
 

Attachments

  • sample file CF Monday.xlsx
    8.5 KB · Views: 3
You must log in or register to reply here.
Back
Top