Forum Discussion
Solved
Conditional formatting multiple cells
Hi, I'm currently working on a spreadsheet where you can fill in which jobs are done and on what date they were completed. At the end their are 2 columns labelled Query Issued and Query answered ...
Hello ExyteNLowe,
You will need to remove the absolute references from your formula.
Change your conditional format formulas to the following:
=IF(K4="",FALSE,TRUE) and =IF(L4="",FALSE,TRUE)and in the Applies to section of the Conditional Formatting Rules Manager, apply the rule to the necessary range.
Hello ExyteNLowe,
You will need to remove the absolute references from your formula.
Change your conditional format formulas to the following:
=IF(K4="",FALSE,TRUE) and =IF(L4="",FALSE,TRUE)and in the Applies to section of the Conditional Formatting Rules Manager, apply the rule to the necessary range.
That's worked perfectly, Thanks
