Tryingtoresolve
New Member
- Joined
- Aug 28, 2023
- Messages
- 24
- Office Version
- 365
- Platform
- Windows
I'm trying to add a formula within conditional format so when N/A is entered in L2 cell it them automatically adds N/A to 3 others cells of K2 M2 O2is this you want to change colour of the cell - or something else - POPULATE ???
you exanmple shows K,L,M,O with N/A
NOT just
as stated
Thank you anyway for the helpcannot do that with conditional formatting
probably need VBA - not something i provide on these forums