How can you change the bkcolour of only one row in the detail section

[andy49]

Users have the option to change the final column. If they change it, the program tests the new value and I'd like to turn the background red.



As you can see. I'm turning every one red. It must be easy!! Who needs to change all the names??


If it can't be done I'd value any workarounds.

Many thx




Sent from my iPhone using Tapatalk

[pbaldy]

Look at Conditional Formatting, on the ribbon. You may be able to adapt whatever your code tested for.

[andy49]

Thanks mate. Definitely what I need but it'll take a while getting the right format from what I have


Sent from my iPhone using Tapatalk

[pbaldy]

No problem, post back if you get stuck.