Hi all,

I am having an issue with a conditional formula that is based on a formula.

What I am trying to achieve, is that if a growth rate calculation in a cell matches the value of a specific cell, then the growth rate calculation should be shaded a specific color.

For some reason, this calculation is not working for some cells in my workbook.  I have confirmed that the calculation and the reference cell DO match.

I have confirmed that the cell the formatting is applied to corresponds ONLY to that cell, not a range of cells.

I am really stumped at why this might not be working.  Any thoughts or suggestions would be very helpful....I would post a sample file if I could.

I would post a sample file if I could.

A sample file is almost certainly required. Include the Conditional Formatting that you have tried.

Guidelines to upload a workbook on OneDrive:

1. Zip your workbooks. Do not just save to OneDrive because the workbooks open with On-Line Excel and the limited functionality with the On-Line version causes problems.
2. To Zip a file: In Windows Explorer Right click on the selected file and select Send to -> Compressed (zipped) folder.)
3. Do not use 3rd party compression applications because I cannot unzip them. I do not clog up my computer with 3rd party apps when there are perfectly good apps supplied with windows.
4. Go to this link.  https://onedrive.live.com
5. Use the same login Id and Password that you use for this forum.
6. Select Upload in the blue bar across the top and browse to the zipped folder to be uploaded.
7. Select Open (or just double click). (Be patient and give it time to display the file after initially seeing the popup indicating it is done.)
8. Right click the file on OneDrive and select Share.
9. Do NOT fill in the form; Select "Get a Link" on the left side.
10. Click the button "Create a Link"
11. Click in the box where the link is created and it will highlight.
12. Copy the link and paste into your reply on this forum.

Hi Misfits,

You can depend on OssieMac's steps to share your file via OneDrive.

Or you can send the sample file to our email address:
ibsofc@microsoft.com
Please Note: Please add the URL of the case in the email subject or body.

I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su