-
1. Re: How to Remove color on Cell
Simon RuncJan 30, 2018 5:15 AM (in response to chandrakanth k)
Something like this would do the trick...
create a formula like this
IF [Month] != 'Jan' THEN [Meeting Types] END
and use this on your colour tile and change the NULL colour to white.
Hope that helps
-
2. Re: How to Remove color on Cell
chandrakanth k Jan 30, 2018 5:37 AM (in response to Simon Runc)Hi Simon,
I tried the formula and it complete clears color formatting for Jan month. I just want to keep Jan 17th in white.
Regards,
Chandrakanth.K
-
3. Re: How to Remove color on Cell
Simon RuncJan 30, 2018 5:52 AM (in response to chandrakanth k)
Apologies...I read it at January 2017!!
So we can make a slight change to the formula
IF [Date] != #17/01/2018# THEN [Meeting Types] END
-
4. Re: How to Remove color on Cell
chandrakanth k Jan 30, 2018 6:42 AM (in response to Simon Runc)Hi Simon,
Its worked. Thank you so Much.
Regards,
Chandrakanth.k
-
5. Re: How to Remove color on Cell
chandrakanth k Jan 30, 2018 7:00 AM (in response to chandrakanth k)Hi Simon,
If I need to use this formula for multiple dates then should I use Else if?
For example I need to enable this change for 15th,16th & 17th Jan. How do I write calculated field?
Regards,
Chandrakanth.K
-
6. Re: How to Remove color on Cell
Simon RuncJan 30, 2018 7:06 AM (in response to chandrakanth k)
You should be able to just add them all in a single IF, with and AND between each date you don't want....something like
IF [Date] != #17/01/2018# AND [Date] != #15/01/2018# AND [Date] != #16/01/2018#
THEN [Meeting Types] END