• 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.

highlighting a cell based on rows and columns

M

mrsteve

New Member
I have a grid in e3 to ae22 with weights in column e and distances in row 22. Based on certain formulas, I want to highlight the cell that intersects both results. For instance, if the weight is 3326 and the distance is 89, I want to highlight cell v8.


I am close, I think, but just can't quite get the right formula.


Any help would be appreciated...
 
Hi, mrsteve!


You can try this:

a) define a helper column with a formula that sets values to TRUE/FALSE

b) play with formulas there till you get the desired result

c) then copy it and add to the formula field for conditional formatting, taking care of adding the $ to fix columns if you need a wider range to highlight across rows.


If you can't manage how to write that formula, well, you can always upload a sample file with the complete specifications for highlighting. Give a look at the second green sticky post at this forums main page for uploading guidelines.


Regards!
 
Conditional Format, new rule, formula is

=AND($E3=DesiredWeight,F$22=DesiredDistance)

Set fill color, ok out.


Change DesiredWeight and DesiredDistance to appropriate, absolute cell references. (e.g., $A$2).
 
You must log in or register to reply here.
Back
Top