Highlighting Cell When Another Cell Contains Text

[americantuna]

Hello all,

I was wondering how I can go about highlighting a cell (i.e. B2) if another cell in its row (i.e. O2) contains text.

I don't want a rule that says specific word or words must be entered, just if the cell contains ANY text.

I also then want to copy that rule all the way down the sheet so that each row only checks its own row.

I basically want to use it to highlight the first cell to indicate that there are notes (Column O will be a notes section) in that row so I don't have to keep scrolling over to check.

I feel like this would be simple, but I'm sitting at my desk at work and my mind is just blank. Any help would be appreciated.

 

[Joe4]

Welcome to the Board!

To apply it to cell B2, use the formula option of Conditional Formatting, and enter this formula:

=ISTEXT($O2)

To apply it to multiple rows at once, select the entire range you want to apply it to, then write the formula as it pertains to the first cell in your selected range.
Excel will automatically adjust it for the other rows.

 

[americantuna]

Wow. Yeah, I knew it was something simple.

Thank you VERY MUCH for the help.

 

[americantuna]

Welcome to the Board!

To apply it to cell B2, use the formula option of Conditional Formatting, and enter this formula:

=ISTEXT($O2)

To apply it to multiple rows at once, select the entire range you want to apply it to, then write the formula as it pertains to the first cell in your selected range.
Excel will automatically adjust it for the other rows.

Actually, one more question. If I wanted to do a OR function using this same setup, how would I do it?

For instance, if I wanted to highlight if there is text in either O2 or J2?

 

[Joe4]

For instance, if I wanted to highlight if there is text in either O2 or J2?

Try:

[COLOR=#333333]=OR(ISTEXT($O2),ISTEXT($J2))[/COLOR]