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

Conditional Formatting

akinkaraman

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

Can you help me?

Thanks..
 

Attachments

  • FORMULA.xlsx
    12.8 KB · Views: 0
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.
 
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.
 

Attachments

  • FORMULA 2.xlsx
    11.5 KB · Views: 0
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.
 

Attachments

  • FORMULA 2 (1).xlsx
    12.4 KB · Views: 0
Back
Top