Hi all..
i want a cell to change from % format to $ when the value of another cell is 1 or 2!
I do enter formula conditional formatting:
=B6=1 do % formating...
then for the same cell
=b6=2 do $ formatting...
I change the selection but the formatting remains the same!!
Please outline the XL version you're using this with (better yet add this to your profile) - presumably XL2007 or later ?
Post a sample file.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
here is the file with the problem
sorry .. I use Excel 2007
works for me - I get 20% if D15 = 1, $0.20 if D15 = 2 else 0.2
Are you running with Automatic Calculation ?
yep.. i checked that twice.. ok ..then i ll check if my file is too heavy..and overloads
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks