Conditional Formatting

[brandonmcg]

I am dumb and I cannot understand how to do this. I read and watched videos and still I am struggling.

The spreadsheet I am working with is a hundred or more rows.

If D2 is greater than 01/01/1990 then E2 is true or false. This can be null or not null. I need the row to color code.
If D3 is greater than 01/01/1990 then E3 is true or false. This can be null or not null. I need the row to color code.
etc.

For each row I need the entire row highlighted if D is greater than 01/01/1990 or if it is better null or not null.

So reading it appears I need the true or false in column E.

I cannot figure out other than to do it row by row to cover the whole spreadsheet to look at the results by row to color code.

Make sense?

I tried to use the format copy and paste but the conditional format option disappears so I am doing something wrong either with the formula copy and paste.
What is the formula and how do I apply?
How do I cover the entire spreadsheet to apply the conditional formatting?
Too broad of a question?

 

[DRSteele]

Select the entire sheet. That can be done by selecting the downward triangle above the first row of the grid to the left of the first column.
Select Conditional Formatting | New Rule | Use a formula.
Put this in the 'Format Values where...' box: =$D2>=32874
Select a format you like and engage the operation by pressing Ok all the way out.

That should format every row where the value in column D is greater than or equal to 1/1/1990, which is Excel Serial Number 32874. [You could enter this value into the spreadsheet somewhere and refer to it in the CndFrmt formula.]

 

[brandonmcg]

Thank you! Thank you! Thank you!

 

[DRSteele]

You're welcome.

This video really does a super job of illuminating CondFrmt, which can be baffling at times.