Conditional Formatting

brandonmcg

New Member
Joined
Jan 14, 2009
Messages
43
Office Version
  1. 2016
Platform
  1. Windows
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?

1641330899318.png
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
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.]
 
Upvote 0
Solution
You're welcome.

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

Forum statistics

Threads
1,213,524
Messages
6,114,117
Members
448,549
Latest member
brianhfield

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top