I want to use Conditional formatting so all of the cells in column A change colors whenever the matching cells in column B have the word "later". ex: If cell B20 contains "later", then I want A20 to change colors. (font or fill, anything)
I've tried everything, nothing seems to be working.
My range is A10:A998
And my custom formula is: =$B10:B998="later"
I've also tried it without the $ sign in the beginning.
Is this rule not working because I have another rule for column A? The other rule changes the text color if it contains a check mark, but that is only within its own column.
Does anyone know how I can fix this?
