Conditional formatting by results in two different cells

  • Thread starter Thread starter Supe
  • Start date Start date
S

Supe

I want my background to highlight red if the cell in column D AND the cell in
column L are both less than zero.
 
One way:

Assume the cell to have the CF applied is in Row 2:

CF: Formula is =AND($D2<0,$L2<0))
Format1: <pattern>/<red>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 1
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Conditional format a column based on value in a different column 3
Conditional formating a cell containing a date 1
Highlight Highest Amount 2
Excel Conditional Formatting (Compare Vals in 2 Columns) 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1

Back
Top