I have a column with, say, 20 rows. 10 of the cells contain the text "Start". 2 of the cells contain the text "Stop". The remaining 8 cells equal to "".
In another cell (different row and column as above) I have a cell containing "Start".
I select the 20 cells in the Column, choose "Conditional Formatting" , "Format only cells that contain", "Cell Value not equal to Start", Format fill to yellow.
The 2 cells that contain "Stop" fill yellow, but also the 8 cells equal to "". I'm not sure why this happens.
If my desire is to fill only the 2 cell that contain "Stop", how do I fix my formatting?
Thank you.
Bookmarks