Conditional formatting to highlight cell based on value in another cell

[Sandman1985]

Hi All,

Hoping what I am trying to do is possible. Read a few variations on my conditional formatting formula but nothing was successful.

I am trying to conditionally format cells in a table, based on values in a second table.

I have used this formula =IF(BO12="",NOT(ISBLANK('Overall Schedule'!BO9))) and it works - except it is also applying formatting to corresponding cells which contain a formula but no value. Is there a way I can edit this formula to ignore cells with a formula but no value in the "Overall Schedule" sheet?

Any help greatly appreciated.

Regards,

Sandman

 

[SanjayGMusafir]

Not sure but you can try this -

=AND(BO12="",'Overall Schedule'!BO9<>"")

 

[Sandman1985]

Not sure but you can try this -

=AND(BO12="",'Overall Schedule'!BO9<>"")

@SanjayGMusafir - That works great. Thank you so much Sir.​

 

[SanjayGMusafir]

Glad to help you.