Good Morning,
I hope someone might be able to help, I am new to excel and I wanted to get this excel spreadsheet to show:
Green if the batteries are not due to be replaced.
Yellow if its due to be replaced in the next 2 months
Red if they are over due.
I have given a date on install and then 5 years for the battery to be replaced.
I would like the line to colour, but I could only get the cell.
Can anyone help?
Hi
just change your CF as follows =$E2 < today()
Then select the ENTIRE range it applies to (a2:L25, say)
And apply Format as required
No need to create a CF for EACH cell, XL does the job for you . (The position of the cell ref is important)
So does that mean I cannot have for example Line 16 as its due in the next month it to show yellow? and as the others are in the future green?
Not at all, you have to create other CF rules for those other colors with the same range.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks