Hi
Anyone know the formula to conditional format to highlight all the dates only showing 2013?
thanks
Y
Hi
Anyone know the formula to conditional format to highlight all the dates only showing 2013?
thanks
Y
In CF use
=year(a1)=2013
or
=YEAR(A1)=year(today())
format
Life's a spreadsheet, Excel!
Say thanks, Click *
thank you for your help
key is to use row relative reference.
Use formula to decide which cell to format -->
Formula:
=YEAR($A2) = 2013
Assuming column A has dates
Regards,
Vandan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks