Hello and thank you to the Excel experts.
I have spent hours on this and finally gave up. I developed a Conditional Formatting formula that works properly in one cell, but the formula does not copy properly to other cells (I need some of the cell references to be relative but they copy as absolute). I need to copy this for hundreds of cells. I have attached the spreadsheet that includes the problem statement.
Thank you! Tim.
Try thisFormula:
Please Login or Register to view this content.
The row number needs to be absolute.
Same for red
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hello Trevor. Thanks for the advice. I copied the solution into my Excel but it did not work. I've attached an updated sheet to explain my problem better... let me know if you can solve this. Thank you. Tim.
Try:Formula:Please Login or Register to view this content.
Hello Trevor. That worked! I don't understand how it works, but it works (I expected the formula would be different in every cell after I copied and pasted it... like Excel normally changes the relative cell references when you copy and paste them). Thank you for the help. This will make the spreadsheet much more useful for our team. Have a great day. Tim.
You're welcome.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks