LinkBack URL
About LinkBacks
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.
Doesn't work - error with syntaxOriginally Posted by nflsales
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.
Doesn't work - error with syntaxTry 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
just opened conditional formating=>new rule=> and past yours formulas.
Could You attach file with implement formula? Then I will know what's wrong
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.
Ok guys. I past "and.." but in my language should be "oraz..." now it's ok., but tell mi please. Where could I choose e.g. should be marked only one column not 3?
Ok guys. I past "and.." but in my language should be "oraz..." now it's ok., but tell mi please. Where could I choose e.g. should be marked only one column not 3?
Just change the 'Applies to' range in the conditional formatting editor.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks