Such as if the aircraft is TC-VEL and Cockpit 2 person and cabin 5 person so Index will be 27 at O8 cell. So I18 cell (value 27) will be colored there.
It's fixed. The problem was with countif range which moved down and for 4 it didn't find the match for whatever "
TC-VEL
" this is. As it is done that there are 3 separate Cformats for all tables there can be set absolute reference which is now done.