Forum Discussion
Solved
Conditional Formatting and formulas
Hi there, I was hoping there is someone who could assist me with a worksheet that was created. It has conditional formatting and formulas. The conditional format is if you select every 2 y...
Wyn Hopkins thanks for getting back to me.
When i enter the name into the column it changes to purple after entering the date and I need it to change to green as it is in date.
nicola1505 try to use in your conditional formatting the formula isnumber , to ensure that text input will be filtered out, as date is considered a number, try that