I am trying to conditionally format only empty cells in Column N that coincide with TRUE values in the same row of Column L.
I have managed to find a way to conditionally format using each selection individually with the following code.
=L13:L339=True=ISBLANK(N13:N339)
Despite trying I have not been able to successfully combine the two criteria using AND logic and was wondering if that is the right way to proceed?
For reference, in the image above I would want cell N15 to be highlighted because the value in L15 is true and the cell in N15 is currently blank.
Thanks in advance for any help.
CodePudding user response：
This is how you need to highlight cells where
• L13:L339=TRUE
• N13:N339=""
Please follow the steps to accomplish this task,
• First select the range from N13:N339
• From Home Tab => Under Styles Group ==> Click Conditional Formatting,
• Click New => New Formatting Rule Dialog opens,
• Click on the Last rule ==> Use a formula to determine which cells to format
• In the Edit the rule description paste the below formula,
=(L13=TRUE)*(N13="")
• Click on Format ==> Choose your preferred formatting( Fill Color, Font Color etc.)
• Press Ok Twice. And it's Done.
Note: In the example screenshot I have used range from N13:N16, also to hide the TRUE & FALSE's, I have used a custom formatting, to hide them, select the range press CTRL 1 ==> Format Dialog ==> Number Tab ==> Custom ==> Remove anything that shows below type and write.
;;;
