I would like to stand out records where date = current year and name = john. unfortunately i don't know how to write formula in conditional formating:/
I would like to stand out records where date = current year and name = john. unfortunately i don't know how to write formula in conditional formating:/
Last edited by radek225; 09-28-2015 at 08:07 AM.
Select A2:C13 and use below formula in Conditional Format
=and(year($a2)=year(today()),$B2="John")Please Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Try using
Formula:Please Login or Register to view this content.
Does work - how did you try to use it?
** this applies to both suggestions that were provided **
see the attached file
Would be better if you pasted the formula you have entered, then we could tell you what's wrong with it, probably at a glance.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
What's wrong with the file in post 7?
I've just opened it and it looks like it's doing exactly what you asked for.
Rows 3,7,10 and 11 are green, the rest are not. No sign of any errors.
edit:-
Looking at your sheet name, does your computer have Polish regional settings?
If it does then you might need to replace , with ; in the formula (the same applies to any formula).
Last edited by jason.b75; 09-28-2015 at 07:38 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks