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
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
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.
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
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
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
