Hi friends,
I am using conditional formation with three traffic lamps.
My condition is:
If values greater than =C3*1.25 Red lamp should appear
If Value is greater than =C3*1.25 and less than =C*1.1 Yellow lamp should appear
If Value is >0 then only green lamp should appear
For the value o or less than zero light should not appear.
Kindly help!!!
Satish
Hi,
If you set them up in the opposite order to the way you have described then it should work fine.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks