Using Conditional formatting

[taobert]

In cell f2, I have the value: =d2/e2 (which gives a %) I formatted this cell as a number with 1 decimal place (0.0). I then tried to conditional format it using: Does not = 13.9 and turn the cell a color if it does not equal 13.9 and what happens is all the cells turn that color despite being equal to 13.9. What is the reason for this?

[dogberry]

Hi

Should not happen can you post a sample


To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.



Chris

[Ace_XL]

Formatting only changes appearance and not the underlying value.

Change formula in F2 to
=ROUND(D2/E2,1)

[taobert]

That worked, thanks