takumiirie

記法	記号(ソースコード)
枠	| 内容 |

takumiirie

def midnightConverter(*, year, month, day, hours, minutes):
	totalMin = int(hours)*60 + int(minutes)
	diff = divmod(totalMin,1440)
	if diff[0] >= 0:
		deltaMin = timedelta(minutes=totalMin)
		baseDate = datetime(
			year=int(year),
			month=int(month),
			day=int(day),
			hour=0,

takumiirie

nkf -w --overwrite ./*

takumiirie

# set "Apply to range" to whereever you want to apply setting.

# set "Format cells if..." to "Custom formula is" and paste following code
# Following Forumula will detect if it's match with regex or not.
=REGEXMATCH(INDIRECT("R[0]C[0]", false),"<PUT YOUR REGEX HERE>") = true

# set your "formatting style"

That's it!