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?

  • You have to remember that when it comes to conditional formatting position matters. Top rules override lower ones. Have you tried moving yours to the top? – marikamitsos May 23 at 6:46

custom formula applicable to range A10:A998: =B10="later"


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.