Conditional formattin

Resolved · Low Priority · Version 2013

Tue 19 Nov 2013, 12:22 Delegate 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:21 Trainer 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:21 Trainer 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:00 Delegate 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:47 Delegate 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:07 Trainer Cindy said...