Conditional Formatting Based on 2 cells

Closed
diggity - Feb 6, 2012 at 02:24 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 6, 2012 at 06:26 AM
Hi,

I want to use conditional formatting to highlight a whole row based on text in 2 different cells.

For example: I have 10 columns and I need text from column C and text from column H to say two things that will make the whole row red.

Is this possible?

I've tried using ands, if, and ors without success..

Thanks


Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Feb 6, 2012 at 06:26 AM
"text from column C and text from column H to say two things"
too vague

it is possible either by conditional formatting or a macro
0