Hi. Am looking for a way to change the color of the cell based on a search on matching number and two letters in front of it. As of right now am matching the color with this code:
The two number on the top are always on row 1 and 2, and the cell I want to format is under and can be on row 10-80. Is there an easy way to do this? The reason for the long code is because am adding letters in front of the numbers below:
Its a flight schedule and for now this have been working great until now. The numbers are changing to much and suddenly a Red field is supposed to be blue, that's why am thinking it could be easier if its matching the color based on a match at the top field and if it contains "SK", "DY" etc.
Would this make the Excel-workbook to heavy or could it be done without compromising the size and speed?
=IFERROR(AND(VALUE(RIGHT(A1,LEN(A1)-IFERROR(SEARCH("-",A1),0)))<=399,VALUE(RIGHT(A1,LEN(A1)-IFERROR(SEARCH("-",A1),0)))>=300),FALSE)
The two number on the top are always on row 1 and 2, and the cell I want to format is under and can be on row 10-80. Is there an easy way to do this? The reason for the long code is because am adding letters in front of the numbers below:
Its a flight schedule and for now this have been working great until now. The numbers are changing to much and suddenly a Red field is supposed to be blue, that's why am thinking it could be easier if its matching the color based on a match at the top field and if it contains "SK", "DY" etc.
Would this make the Excel-workbook to heavy or could it be done without compromising the size and speed?