Conditional formatting a cell driven by formula HI I am trying to use this formu

Question

Conditional formatting a cell driven by formula

HI

I am trying to use this formula

=IF(L3="Priority 1: (5 Days)",E3=1,"")

in conditional formatting, to highlight another cell (E1) which is driven by a formula should it result in the number 1. However the formatting (green colour) is not being applied. Any ideas?

I have also applied this formula (as a test) =IF(L3="Priority 1: (5 Days)",E3=or(1,2,3),""). To combine what i want to do which is change the cell colour in E1, which is driven by a formula if it euquals 1, 2, or 3 TO GREEN. but it does not seem to be working. Can anyone tell me where I am going wrong please?

Explanation / Answer

#@When using the *& Use a formula to determine which cells to format option when creating a new conditional formatting rule, the formula only has to resolve to either TRUE or FALSE. The two formulas you provided don't really perform that operation as an empTy string (e.g. "" ) resolves to TRUE (although not an actual boolean result). Perhaps one of these might suffice.

=OR($L3="Priority 1: (5 Days)",$E3=1)

... or,

=OR($L3="Priority 1: (5 Days)",$E3={1,2,3})

if the {1, 2, 3} would still have to be within an OR() as E3 cannot be all three values at once.

=AND($L3="Priority 1: (5 Days)",$E3=1)

... or,

=AND($L3="Priority 1: (5 Days)",OR($E3={1,2,3}))

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.