Forum Discussion
Conditional Formatting and formulas
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
Hi nicola1505
Ah, it looks like a lot of the conditional formatting formulas are misaligned.
If you like I can take a look at fixing it up and then send you the file back.
If it's messed up too much I might have to just point you in the right direction and maybe someone you know, or someone here can assist
Wyn
MVP
UTC+8
Wyn HopkinsThat would be amazing if you could assist me as I am only a rookie at this excel business.
