|Without knowing more about how your sheet is set up,|
it is difficult to suggest a Conditional Formatting solution.
Please read this HOW-TO, which explains the use of the < PRE > tags
and post a small sample of you spread sheet, with both Column Letters
and Row Numbers.