Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Conditional Formatting Based on 2 cells [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 -
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


See more

1 reply

Answer 1 / 1
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 793
"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
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!