よく忘れるのでメモ
基本的には判定条件を”=”で挿入し、”True”の場合に書式が適用される。列値に$指定が必要。
単純な判定
例）A列数値がB列数値よりも大きい場合に着色
=$A1>$B1
演算結果の判定
例）A列数値/B列数値が1以上の場合に着色。
=$A1/$B1>=1
よく忘れるのでメモ
基本的には判定条件を”=”で挿入し、”True”の場合に書式が適用される。列値に$指定が必要。
例）A列数値がB列数値よりも大きい場合に着色
=$A1>$B1
例）A列数値/B列数値が1以上の場合に着色。
=$A1/$B1>=1
We use cookies to improve your experience on our site. By using our site, you consent to cookies.
Manage your cookie preferences below:
Essential cookies enable basic functions and are necessary for the proper function of the website.
These cookies are needed for adding comments on this website.
Google reCAPTCHA helps protect websites from spam and abuse by verifying user interactions through challenges.
Google Tag Manager simplifies the management of marketing tags on your website without code changes.
Statistics cookies collect information anonymously. This information helps us understand how visitors use our website.
Google Analytics is a powerful tool that tracks and analyzes website traffic for informed marketing decisions.
Service URL: policies.google.com (opens in a new window)
Marketing cookies are used to follow visitors to websites. The intention is to show ads that are relevant and engaging to the individual user.
A video-sharing platform for users to upload, view, and share videos across various genres and topics.
Service URL: www.youtube.com (opens in a new window)
You can find more information in our Cookie Policy and Privacy policy.