Complex Conditional Formatting

I am trying to figure out a way to easily format parts of worksheet WSOC 1.0; specifically I want to Conditionally Format the % cells located in WSOC 1.0 D6:O6, etc. based off of information provided in tables within the Prilepin Worksheet. Basically, I want cells such as D6 to format based off of information entered in both Cells D6 and F4, with the formatting matching the cell color of the corresponding information contained within one of the many charts in Worksheet Prilepin.

I have been attempting to use an INDEX MATCH MATCH of Prilepin AF2:DG15 to return the correct difficulty level to WSOC 1.0 C275:F327, and then applying conditional formatting rules based off of that returned value, but it is very tedious. I was hoping that there might be a simpler way to do this?

Basically if WSOC 1.0 D6 is 88% and WSOC 1.0 F4 is 3, then the corresponding points in Prilepin show me that that would fall under category "Very Heavy". I want WSOC 1.0 D6 to format to the cell color Red in this case.

Any ideas and help are appreciated.

I want to CF cells based on a formula return from a cell in a different worksheet. You can see in WSOC 1.0 cell D275 that I have used

Formula:

Please Login or Register  to view this content.

to pull information from Prilepin, and then am Conditionally Formatting WSOC 1.0 cell D6 to a specific color based off of what was returned in D275.

I am seeking an easier/more efficient way to get this done, while potentially addressing some of the flaws with this method.

I want to CF cells based off of a range of options where a search is conducted somewhere within Prilepin (and I may have to find a new way to format the chart/s here), and the return value impacts the CF of a different cell.

I want to search within Prilepin for information contained in 2 separate cells in WSOC 1.0. In Prilepin, if Reps are the Y axis, and % is the X axis, I want to find the intercept of these two points. I then want to CF a cell based off of what that intercept cell contains. Furthermore, I would love it if the % axis did not have to be an exact match, but could round down to the nearest match if it doesn't match exactly.

Does this clear things up?

I think that we are on the right track, but there is still an issue somewhere. The formatting is not correct depending on the percentage, if it is too high or too low it doesn't show either an error, or the new formatting rule that I set for "TOO HEAVY" and "TOO LIGHT". I think that the rounding issue is figured out... just the formatting issue.

I really want an easier way to auto-format all of those cells. It would be great if I could do it without the helper columns, but I am not sure if that is even close to possible.

Maybe with VBA, but that is outside my wheelhouse.

I appreciate the help, and will mark this thread as Solved. I am, ironically enough, using Epley's formula for the percentage charts in Prilepin, so I am very aware of him and his work. Thank you!