Help with conditional formatting:requires comments

[changetires]

Here is what I want to do:

I have a spreadsheet that requires comments to be entered into a cell when a certain cell turns red. What I need to do now is I want another cell to turn red when one of these comment fields does not have a comment entered into. There are 6 of these comment fields located at columns S,W,AA,AE,AI,AM

Can anyone help with this,

Ed

[Maistrye]

Here is what I want to do:

I have a spreadsheet that requires comments to be entered into a cell when a certain cell turns red. What I need to do now is I want another cell to turn red when one of these comment fields does not have a comment entered into. There are 6 of these comment fields located at columns S,W,AA,AE,AI,AM

Can anyone help with this,

Ed

Assuming the active cell is in row 2, in your conditional format, put
=if(and(trim($S2)<>"", trim($W2)<>"", trim($AA2)<>"", trim($AE2)<>"", trim($AI2)<>"",trim($AM2)<>""), true, false)

You can just put and(...) . The If statement wrapper is just one of my habits.

Scott

[changetires]

Lemme try that and stay here Scott and lemme get back to you and see if that will work.

Ed

[changetires]

My active cell where I want the conditional format is C77. When cell M77 turns red then cell S77 should have a comment written into it. When there is no comment written in then I want cell C77 to turn red. Is this do-able.

Ed

[changetires]

bump it back to the top

ed

[Maistrye]

My active cell where I want the conditional format is C77. When cell M77 turns red then cell S77 should have a comment written into it. When there is no comment written in then I want cell C77 to turn red. Is this do-able.

Ed

Yes.

However, for the conditional format for C77, you're going to have to put something like:

=IF(AND([Condition from Conditional Format for M77 that caused it to turn red], TRIM(S77)=""),TRUE,FALSE)

Nothing I've seen indicates to me that you can use the shading of a cell as part of an if statement *unless* you create your own function/macro to do the task. (ie. None of the native functions that I've seen have the necessary functionality -- that said, if such exists, please tell me.)

Scott