column A has dates of birth ... column B is the student name ... column C-F is address information
I want a formula that would make the entire row change to bold font for any student whose birth date is before a certain date.
thanks in advance!
column A has dates of birth ... column B is the student name ... column C-F is address information
I want a formula that would make the entire row change to bold font for any student whose birth date is before a certain date.
thanks in advance!
Use conditional formating something like 'Cell value is' <=$a1
Where $a1 is the date of birth that differentiates what gets bolded and what doesn't, then format the cells 'bold' if they meet the specified condition.
_________________
Regards,
nrage21
Assuming your date is in another cell, such as G1, highlight your table (I'll assume it's A2:F10), go to conditional formatting, in the formula box =$A2<=$G$1. Then, using the formatting tool in conditional formatting, make the font bold.
Edit: Looks like I'm a hair slow.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks