Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses