Conditional Formating

C

Carefree101

New Member
Joined
Oct 23, 2020
Messages
3
Office Version
  1. 2010
Platform
  1. Windows
In the DOB row under the number column I need it to highlight if the person is over 80 years old, for example 01/01/1939 - Highlight light blue. I just can't get my head around this for some reason the formating isn't working.

Any Suggestions please? I can't use date occuring obviously and when I put it in as a value between it doesn't work. Is there a easy formula I could use? TIA



1603663455483.png
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sort by date Sort by votes
You could use some thing like
Excel Formula: 
=AND(B8<>"",B8<=EDATE(TODAY(),-960))
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Solved
How to write a Conditional Formatting Formula inside an Excel Table
Replies
3
Views
78
SanjayGMusafir
SanjayGMusafir
C
  • Question
Conditional Formatting based on age range
2
Replies
17
Views
992
CMW
C
S
  • Solved
Conditional format dates in a range which are x days from today
Replies
3
Views
492
Sallyprit
S
W
  • Question
Colour cell/conditional formatting
Replies
2
Views
116
Webslinger83
W
D
  • Question
Conditional formatting on pivot table headers
Replies
0
Views
145
D_SQUARED
D

Forum statistics

Threads
1,215,440
Messages
6,124,882
Members
449,193
Latest member
PurplePlop

Share this page

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