• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting

K

kmakifl

Member
I am trying to set a rule that if range values are 0 to 24 the cells should turn yellow, if >=25 green. I have one cell with a value of 24 and another with a value of 25, these did not change but remain white, no fill. What step have I missed? Thank you.
 
Select the cells involved, taking note of the first cell eg: D5:H30 will be D5

Set a CF to =and(D5>=0,D5<=24) set Yellow

Set a Second CF =D5>=25 set Green
 
Hi Hui, I know this is supposed to be very simple but I am having a little difficulty with this. I have selected the range,applied your instructions,chose format in lieu of set Yellow. all that fall below 24 highlights but cell with 24 does not.
 
Hi ,


Have you tried doing the Conditional Format on one cell , and then copying that cell format to the other cells , using the Format Painter ?


Narayan
 
Hi kmakifl,


When you say "cell with 24" is it possible that the value is slightly above 24? e.g. 24.001?


Your described requirement taken literally, and Hui's corresponding instructions, do nothing with values > 24 and < 25. Approximately 24.0000000000000000001 to 24.9999999999999999999 if you follow me.


If by "0 to 24" you meant >= 0 And < 25, then just use that logic in the first CF rule:

Code: 
=And(D5>=0,D5<25)


Asa
 
You must log in or register to reply here.
Back
Top