Conditional format issue

[mhope]

I am trying to figure out a conditional format issue, I cant find a solution
I have a sheet with multiple columns, each cell have a formula that will insert dat into that cell, I need a conditional format that o can put into the cells a1:a300 that will turn them red if there are any cells in the ranges C3:C300, D3:d300, G3;G300, H3:H300, K3;K300, L3:l300 and O3:300 that do not have data in them (apart from the formula)

Thank you in advance for any help

[Aardigspook]

Welcome to the forum.

With no data in C/D/G/H/K/L/O do the cells appear blank?
If so, then use this as your formula for column A:

Please Login or Register  to view this content.

Apply it to the range A3:A300 with red fill. Don't worry about the formula only mentioning row 3; Excel will automatically (invisibly) interpret the formula with the correct row number.

[mhope]

Thank you that's perfect, yes the cells appear blank.

[Aardigspook]

You're welcome.
As you've only recently joined, you may not know that you can mark the thread as Solved if you're happy that your original question has been taken care of, so others know there's an answer here. Instructions to do it are in my sig - if you could take a moment to do it, that would be appreciated. Thanks.