Forum Discussion
FORMULA not working with conditional format
I am using an IF statement to copy data from another cell, but I cannot get the conditional formatting to work on the cell containing the formula? I think this is because the conditional formatting is picking up the formula instead of actual value it displaying. Is there a way to automatically get get the formula to paste or copy this value as a true string so that the conditional formatting works ?
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.
8 Replies
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.
