- Joined
- Aug 20, 2015
- Messages
- 1
- Reaction score
- 0
Hi All
I have read lots of Help tutorials on conditional formatting but still cant find what i am looking for.
This is what i am trying to do.
i have 4 rows with a range of cell that i want to get to highlight in a colour if the dates are less than 3 months.
I know one of the ways is to highlight the Selected Cells and then click on Conditional Formatting and you can select highlight cell rules and select the less than rule.and type in =TODAY()+90 it does that which is what i need it to do. but i don't want it to highlight blank cells.
i have attached an example of what i am trying to do with what i have done.
Is there anyway to do this? or is there another way to go about please feel free to advise on which ever way it can be done.
Thank you for your assistance, its greatly appreciated.
I have read lots of Help tutorials on conditional formatting but still cant find what i am looking for.
This is what i am trying to do.
i have 4 rows with a range of cell that i want to get to highlight in a colour if the dates are less than 3 months.
I know one of the ways is to highlight the Selected Cells and then click on Conditional Formatting and you can select highlight cell rules and select the less than rule.and type in =TODAY()+90 it does that which is what i need it to do. but i don't want it to highlight blank cells.
i have attached an example of what i am trying to do with what i have done.
Is there anyway to do this? or is there another way to go about please feel free to advise on which ever way it can be done.
Thank you for your assistance, its greatly appreciated.