|Well, there a few things I see in your post that don't make sense.|
First, it does not appear that you copied your formulas directly from a spreadsheet, since they are not capitalized. When you type them into your post "freehand" there is always the possibility of a typo.
That might explain some things since the formulas you posted will not work:
Both of these formulas are missing parenthesis and therefore will never return TRUE
The correct syntax should be:
Note the additional parenthesis before the second equal sign.
Second, I'm not sure why you are using the MID function since your start_num is 1.
Why not just use LEFT?
Finally, are you trying to conditionally format individual cells based on the values in the corresponding rows?
Typically, when you are using CF, you select an entire range and then enter the formula for the first cell in that range and let Excel update the CF formula for all the rest.
For example, if I wanted to CF cells in A1:A200 based on values in C1:C200 and G1:G200 on a row by row basis, I would follow this procedure:
1 - Select A1:A200
2 - Enter this CF Rule:
When I do this, for any row where the 2 criteria in Columns C and G are met, that row in Column A will be formatted by the CF rule.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.