Conditional Formatting

[akinkaraman]

I need a CF formula to show the value of O8 cell at the table in different color.

Can you help me?

Thanks..

 

[tomas]

you did not specify any conditions based on which this cell should be formatted

 

[akinkaraman]

The colored CF will be in the table.

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.

 

[akinkaraman]

I am sending a new file. It has a Conditional Format but it doesn't show when The Cockpit Crew is 4. I need to fix it.

 

[tomas]

Hi

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.

 

[akinkaraman]

Thanks. Great..