CODEWITHSUNDEEP
excelexcel-formulaconditional-formatting
Cont456
Cont456

Reputation: 3

How to highlight a cell with 2 parameters in Excel conditional formatting

I need to highlight individual cells in a column if: 1)that cell is todays date or in the past 2)if the cell next to it is blank

Both of these conditions must be true but I'm having a hard time using IF/AND statements

Sample Data

In this image I would need only D2 to be highlighted

I've tried and failed with all these formulas in conditional formatting

=AND(TODAY()-1,INDIRECT("RC[1]",ISBLANK)

=IF(ISBLANK(INDIRECT("RC[1]"))AND(TODAY()-1))

=IF((ISBLANK($E10))*($D10<TODAY()))

=IF(($D10<TODAY()),"",IF(ISBLANK($E10),""

=AND(ISBLANK($E10),$D10<TODAY())

Upvotes: 0

Views: 120

Answers (1)

RabbitMT
RabbitMT

Reputation: 118

Conditional formatting doesn't use 'If' statements because it's understood, so you were closer with your =AND statements.

Try:

=AND($A2<=TODAY(),ISBLANK($B2))

Place this formula in the conditional formatting and adjust the cell references for A2 and B2 as needed. Then set the formatting and apply it to the rest of the column.

Upvotes: 0

Related Questions