Conditional Formatting and Formulas

Hello,
I would like to color the cells in the A column if columns C through V are empty. I want no color if at least one of those columns has an "X" in it. I have tried variations using If and Countif formulas. I have attached a snippet of the table. Thank you in advance for any help you can give.

Here is a sample sheet.

Hope this could help

Sample Conditional Formatting Sheet.xlsx

BTW, here's your sheet back with the Conditional Formatting as discussed:

Originally Posted by DaveDeV

Attachment 236245

BTW, here's your sheet back with the Conditional Formatting as discussed:

Thank you!!! That works perfectly.

Here one that works...

In conditional formatting use Formula Option and, in the cells you want highlighted, use formula-based formatting with

=(COUNTA(ColumnsC-X)=0 (COUNTA counts non-blank cells in a range and Zero return means all blank)

Dave

Glad to be of assistance...