Forum Discussion
Solved
Excel formula to auto format cell based on value and phrase in second cell
Hi All, I have a formula query that has stumped me! I have a form that records various pieces of data and in one section it asks for payment terms. I have a simple conditional format in place ...
Select Cell 1.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=AND(Cell1>=1, Cell1<=30, Cell2="Days NET")
You have to replace Cell1 and Cell2 with the correct cell references of course.
Click Format...
Activate the Fill tab.
Select green as fill color.
Click OK, then click OK again.
Ah fantastic! Thank you - this is perfect. I was trying to put it into an IF formula which explains why i couldn't work it out. I'm not as familiar with AND formulas so hadn't thought of it.
Thanks so much! 😃