Hi,
I have a Options Trading spread sheet which has a column (E5:E35) with the Header (in merged cells E3 & 4) with the text Call Put. I added two conditional formatting rules to E5:E35 which color the cells green when I type the letter C and red when I type P.
Strange thing is when I type the C, Excel inserts the header text Call Put (green BG and text) instead of just C. The rule works when I type P (goes red).
When I change the header text to Put Call the rule works for C but not for P. Somehow Excel reacts to the first letter of the header even though the 2 header cells (3 and 4) are not included in the cell range 5:35.
What is it that I am missing here. I know it's something simple. Any ideas?
Bookmarks