Conditional Formatting

Resolved · Low Priority · Version 365

Wed 5 Jan 2022, 11:51 Edited on Wed 5 Jan 2022, 11:53 Delegate Joanne said...

Joanne has attended:
Excel Intermediate course
Excel Advanced course

Conditional Formatting

I have just ticked the 'Stop if True' on my blank one, and that has changed it so I am okay now, sorry!!

Hi,

I have a column of data with varying %'s. I am using conditional formatting to out green anything below 0 which works fine, then between 0-10% in yellow which also works fine. I then went to put anything in orange above 10%, but it turns all of the blank cells orange as well. Why would that happen? I have tried adding a final rule for blanks to have no fill, but it doesn't help (it was in the right order when I did that).

What am I doing wrong?

Thank you,
Jo

Thu 6 Jan 2022, 11:36 Trainer Martin said...

RE: Conditional Formatting

Hi Jo,

Thankyou for sending this question.

It seems you have resolved the problem of blank cells not changing to a set colour through using the 'Stop if true' setting. If this is the case, please let me know so we can mark this post as resolved.

If not, I can look at the issue for you. One thing I have noticed when setting multiple rules on selected data is that the blank cell rule to have no formatting accidentally becomes part of another rule (ie. 0-10%) and so will turn that colour. it looks like you have already sorted the order of priority for the 'blank cell' rule (via Manage Rules) by moving it to the top of the list.

Let me know if you would like to proceed further with this issue

Kind Regards

Martin

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Creating charts in Excel 2010

Here's how to present your data in a chart format:

Highlight the data you wish to use in a chart

Click the Insert Ribbon

In the Charts Group, select Column Chart

Your chart will then appear on your work sheet.

View all Excel hints and tips