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.
That's worked perfectly, Thanks