Conditional formatting with color coding is not working

I find this extremely hard to decipher, and your CFs are both numerous and complex.

Can we go back to basics there may be a simpler solution.

Would you give examples of which specific cells you wish to compare, why you choose the cells and what the rules for comparison are. Please write this down rather than some diagram.

Hi,

Sorry, I'm non the wiser. I've no idea why for instance comparing the digits of the two numbers in C4 & D5 apparently produce the two numbers 12 & 17. and then how you use that information. Then I don't know whether every one of the 60 numbser is compared with the other 59 numbers or just numbers on the row below or something else

Remember that when you ask a question in a forum those of us who might be able to help know absolutely nothing about your system and work process or the terminology you use. Unless you have uploaded a workbook we know nothing about how it is laid out and little about what you want done with it or how the results should be presented.

It always helps to explain what the data represents and then to know whether whatever it is if captured in a different layout might be easier to analyse. Don't assume that you're chosen methodology is the optimum. It may be but may not.

Whilst these things are second nature to you since you live with the workbook all the working day we start with zero knowledge so you need to take us by the hand and explain in quite precise detail your aims and goals as well as stuff like how your data might look different in other situations.
Don't assume we are able to "figure it out". We're usually quite good but not psychic.

Put yourself in our position and think about whether what you've posted makes sense and is unambiguous to someone who's never seen it before. You are asking us for help so help us to be able to help you by providing all the information we need, even if that information seems obvious or intuitive to you.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here, I will do it for you today: https://chandoo.org/forum/threads/co...working.47000/.)

@Richard Buttrey

lets start with the top section (2 grids)

the cells are colour formatted based on the difference between the numbers in the same position of grid 1 and 2... for example 99-66 = 33 (or perhaps i should say 77, if you use the table on the right) and is a dark red colour. so if you have another pair of numbers with a difference of 33 (77?) then they will also be dark red, and then you will have 4 cells with the same dark red colour... so this establishes that the difference between two relative cells will determine its colour, and that any other pair of relative cells with the same difference will also be the same colour.

with that out of the way, lets look at the apparent "problem", it is claimed that the formula is not working.... HOWEVER... there appears to be a clue in the drawn lines between the short text formulas to the side.

if you look quickly at the formulas for grids 1 and 2 you see there is direct lines drawn below 66 to 28, and from 80 to 42... whereas grids 3 and 4 are crossed 74 to 86 and crossed 73 to 76.

so what i did was i switched all the numbers in grid 3 .. back to front of grid 1, and made sure that grid 4 was identical to grid 2... and all the colours line up on all 4 grids.

except for A36 and A47, which is to demonstrate that the difference is based on the reverse of the number, not the number you see, in this case the difference is 13, which is light green.

what these grids are for?... i have no idea... but it seems to be a puzzle

i have attached the edited sheet.

sidenote: i had seen this spreadsheet before, it was posted on Chandoo almost 2 years ago for exactly the same claimed issue of "formula not working", and asking users to "fix it", while a new thread just placed on 5/oct is persisting with the same claim.
https://chandoo.org/forum/threads/co...g-issue.43575/

sir thank you so much u have come very close to my problem
kindly notice in grid 1 and 2 ,some of the cells are highlighted with same colors within grid 1 and 2
thats what for i have shown the examples. it will calculate according to the formula and within the grid also there ll be same difference between the cells sir
the out put of formula is different and between cells the difference is different kindly notice grid 1 and 2 66 and 28 have same color 80 and 42 have same color and the output is 24 for both.
it should check in grid 1 and then grid 2 then it should highlight sir
now i ll upload another file kindly check it sir

{the cells are colour formatted based on the difference between the numbers in the same position of grid 1 and 2... for example 99-66 = 33 (or perhaps i should say 77, if you use the table on the right) and is a dark red colour. so if you have another pair of numbers with a difference of 33 (77?) then they will also be dark red, and then you will have 4 cells with the same dark red colour... so this establishes that the difference between two relative cells will determine its colour, and that any other pair of relative cells with the same difference will also be the same colour.}

Crossposted at: https://chandoo.org/forum/threads/co...working.47000/

Reminder to all looking at this thread. OP has consistently ignored moderator requests to follow forum rules.