Hi all
Thanks in advance to anyone who solves this for me - It's been annoying me for too long now.
Basically I want to set up a conditional format which highlights a row red when a product is older than 4 years old.
The formula I use for this is :
=$H2>4
This works and is fine, however it also highlights any rows which do not have any value in them at all. So I basically want to know what formula to use to highlight only rows that have a 'value' that is over 4 and if there is no value to leave it blank. Hope this makes sense!
Thank you!!
Bookmarks