Conditional formatting for 2 cell value

[argandoz]

Hi! Guys,

I have an spreasheet where column "D" to column "Z" is formatted with currency and formulated. Column C is date formatted for "DATE RECEIVED". If d2...z2 AND c2 are blank, leave as ease. However, if c2 is filled with date and any of the cell from d2 to z2 contain a value, that cell (any from d2 to z2) will be highlighted with yellow, value will turn to red and font shall be bold. the rest of the cell will remain as ease.

Can anyone out there find me conditional ormtting solution for this.

Thanks.

Argandoz

 

[xenou]

Place your cursor in Cell D2 First, then pull to Z2 to select the range:

Format | Conditional Formatting ... | Formula is

=And(Len($C2)>0,Len(D2)>0)

Set formatting and enter...this should apply to all the cells from D2 to Z2 properly. Then copy the formatting down the column.

Does that work?

Alex

------------
Edit: maybe this works for both your criteria #1 (some cell in D2 to Z2 must have a value) and criteria #2 (that cell will have formatting applied) -- since if the #2 is true, #1 must also be true.

 

[argandoz]

Thanks. That works pretty well.

Argandoz