Forum Discussion

joshdoms2's avatar
joshdoms2
Copper Contributor
May 18, 2019

Formatting cells based on another cell in same row

Hi there,   I am working on an excel document and I created a conditional format in order to change the color of a cell based on the date. The formula is: =B3-TODAY()+365>=30   What this does is ...
excel
Formulas and Functions
Rich99's avatar
Rich99
Iron Contributor
May 19, 2019

HI joshdoms2  I assume that you have only applied the rule to a set cell i.e $B3. Under Manage Rules, expand the selection the rule applies to, such as $A$1:$C$143

Resources