98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional formattin
Conditional formattin
Resolved · Low Priority · Version 2013
Tue 19 Nov 2013, 12:22Delegate Siobhan said...
Siobhan has attended:
Excel Intermediate course
Excel Advanced course
Project Management - Framework & Processes course
PowerPoint Intermediate Advanced course
Conditional formattin
Hi there,
I am trying to have conditional formatting with three factors
1. red fill and text: if cell >=-30
2. alternate row colour: =MOD(ROW(),2)=1
3. No formatting: when cell = NA
For some reason the conditional formatting is picking up cells that contain 'NA' as >=-30 and applying rule 1.
I have tried adding a rule and removing a rule for cells that ="NA" but neither working.
Basically, for cells containing NA I want the conditionally formatting rule 2 to apply but not rule 1.
Hope fully this makes sense...
Thanks,
Siobhan
Wed 20 Nov 2013, 15:21Trainer Cindy said...
RE: conditional formattin
Hello Siobhan,
Thank you for your question regarding conditional formatting.
I've experienced the same issue myself and the way around it is a method you've already tried. Setting up a condition for the text NA.
Since that hasn't worked for you, I want first check which type of conditional formatting you've been using for 'NA'.
The most suitable option is 'Text that Contains...' under 'Highlight Cell Rules'.
If that doesn't work try 'Equal To...' under 'Highlight Cell Rules'.
If neither of those options work, is it possible to email me the worksheet at: info@stl-training.co.uk.
Subject : for Cindy - forum
Hope this helps.
Kind regards
Cindy
Microsoft Office Trainer
Wed 20 Nov 2013, 15:21Trainer Cindy said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Mon 2 Dec 2013, 09:00Delegate Siobhan said...
RE: conditional formattin
Hi Cindy,
I sent an email to info@stl-training.co.uk on 26/11 with the cells of the spreadsheet I am having difficulty with attached. Did you receive this email? Please let me know if you would like me to resend it.
Thank you,
Siobhan
Mon 17 Feb 2014, 14:47Delegate Siobhan said...
RE: conditional formattin
Hi there,
I am following up on this question, which remains unresolved.
I did send an email into info@stl-training.co.uk with the spreadsheet attached however never received a reply.
If you can please assist me with what to do next that would be great.
Thank you,
Siobhan
Wed 5 Mar 2014, 12:07Trainer Cindy said...
RE: conditional formattin
Hello Siobhan,
I've just sent you an email with an attachment that should help solve this issue.
Kind regards
Cindy
Microsoft Office Trainer
Wed 12 Mar 2014: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use. |
