Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

conditional formatting

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional Formatting

Conditional Formatting

ResolvedVersion 365
Edited on Wed 5 Jan 2022, 11:53

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

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

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.