In the attached, I am trying to create a rule for the business I am running. I need a rule applied to the entire column if the upcoming review says past. I need every row to have a strikethrough (line through the word) for the entire column that shows Past. In the attached row 6,8,11,12 will have every cell have a strike through.
I also need to have the review date formatted to blue text if the review date falls on a saturday or sunday. Not sure how to make a rule for this.
will this work for you
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
With all those cells selected (i.e. A5:G12), click on Conditional Formatting | New Rule | Use a Formula... , then enter this formula in the dialogue box:
=$D5="Past"
Then click the Format button, and on the Font tab click against Strikethrough, then OK your way out.
For the second part, highlight the cells F5:F12, then click on CF | New Rule | Use a Formula... , and enter this formula in the box:
=WEEKDAY(F5,2)>5
then click the Format button | Fill tab and choose your colour (blue), then OK your way out again. Excel will automatically adjust the cell references to suit your selected cells each time.
Hope this helps.
Pete
Last edited by Pete_UK; 03-18-2014 at 02:59 PM.
That works for the stirke through however the review date needs to be formatted in blue if it shows saturday and sunday. Also I had a formula in there if ALERT is seen I needed only the world ALERT to be in red. Looks like the strike throughs are all red now.
See attached file - the condition for ALERT is still in there.
Hope this helps.
Pete
He maybe talking about mine Pete....I didn't see the request for blue...I have everything in there now...
I prefer to describe how to set it up (after I've done it), as I doubt the file is the real one so the OP will need to set it up in that - I had my file from the testing, so it was easy enough to attach it.
Pete
@Pete....I totally understand that....and it's weird....it really depends on the mood I'm in at the time, or maybe if I'm time pressured because I'm doing 4 things at once, I'll put the file out there...and then explain if they have questions....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks