Conditional Formatting Formula

[Tryingtoresolve]

Good morning I am trying get get a conditional formatting to change 3 cells when one cell states N/A

When L2 = N/A it populates K2 M2 O2 with N/A

 

[RoryA]

It's not really clear what you are saying. CF will not populate cells. You can use it to highlight them using the formula =$L2="N/A" if that's what you meant?

 

[etaf]

is 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

K2 M2 O2

as stated

 

[Tryingtoresolve]

is 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

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 O2

The cells of K2 M2 O2 cannot have a formula within the actual cell as other data can be updated within it this is why I asked if it was possible to use conditional formatting

 

[etaf]

cannot do that with conditional formatting
probably need VBA - not something i provide on these forums

 

[Tryingtoresolve]

cannot do that with conditional formatting
probably need VBA - not something i provide on these forums

Thank you anyway for the help

 

[Peter_SSs]

@Tryingtoresolve
Please don't mark a post as the solution to your question unless it does in fact contain a solution. 'Mark as solution' removed from post #4