Forum Discussion
FORMULA not working with conditional format
Thanks for the clarification. See the attached version.
You had rules for most individual rows; I have reduced it to 4 rules for the entire range.
Conditional formatting acts on a cell's value, not on its formula.
Could you attach a small sample workbook demonstrating the problem, and explain what the conditional formatting rule should do?
hi Hans
the conditional formatting is between two cell values to determine if the entered results are within limit or not, any rows marked x are to be manually entered results, this works fine. but it is when the data is copied on the rows that are not marked that doesn't work with conditional formatting.Thanks! The problem is that the values in B16:B32 are text, so the mess up the numerical comparison when used in the formulas in M16:P32.
You can correct this as follows:
- Select B16:B32.
- Change the number format from Text to General.
- On the Data tab of the ribbon, click Text to Columns, then click Finish without changing any settings.
the report has data imported from another software so row B automatically turns back into text format, when changing text to columns it removes the decimal places in column B, the decimal places need to remain the same. its very close to what I am after ! is there any other ways to do this so it automatic and the decimal places are not changed?
I have attached the blank template and the exported results prior to what you have said below. it doesn't matter that not all of the values exported are not be in-between column G and H. if you could take another look at this it would be much appreciated.
note - it is the QA tap in reference to our subject / topic
