Conditional formatting

[Qusai82]

hi,

i need your help with the below formula :

=IF($U$38>=61, " ")+IF($U$38<=68, " ")

If the number in cell U38 is less than or equal to 61, the formula returns "nothing" Otherwise, the function colors same cell to Amber for example

im having four colors

thank you for help,
Q

[sathiyamoorthy]

Hi,


please post the attachment and explain the same

[Punnam]

what about 68 u have mentioned in u r formula ?

Punnam

[Qusai82]

sorry i meant :
If the number in cell U38 is less than or equal to 61 & if If the number in cell U38 is less than or equal to 68, the formula returns "nothing" Otherwise, the function colors same cell to Amber for example

so any number falls between 61 & 68 to color
thanks again

[sktneer]

For conditional formatting to work, you need a formula which returns True of False. Select U38 and use the below formula to make a new rule for conditional formatting and set format as per your choice.

Please Login or Register  to view this content.

Is this what you are trying to achieve?

[Qusai82]

i tried that before and now as well didnt return the result, i would love to attach the sheet but i dont know how.
tks
Q

[sktneer]

To attach a sample workbook, click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Qusai82]

i did, thanks sktneer

[sktneer]

See the attached.

[Qusai82]

its solves the problem partially, but when it hits 69 or 61 goes white

[Qusai82]

my mistake it rounded up from 60.5

[sktneer]

If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.