Conditional formatting

Copper Contributor

Hello,

I need some help with a conditional formatting formula please!

If I wanted the cells in column H to be formatted when the value in the corresponding cell in column F equals 'Positive', what formula would I have to enter?

izzybarton_1-1677514388101.png

 

Thanks!

 

 

1 Reply

@izzybarton 

PeterBartholomew_0-1677515531122.png

Mind you, this is functionality that is desperate for an update.  No structured references, no array formulae; just a sad relic of past working practices. :unamused_face: