To highlight or catagorize the data

Closed
stha_naren Posts 1 Registration date Saturday March 27, 2021 Status Member Last seen March 27, 2021 - Mar 27, 2021 at 08:44 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 20, 2021 at 11:54 AM
Hi,
I am willing to prepare the data under the catagory used and unused list checking the data table (data_plan)
suppose C4A-R1 is placed in any cell of data_plan , either the cell containing value turn green or listed to different table called used
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Apr 20, 2021 at 11:54 AM
Hi Stha,

Is it ok to lookup any value entered in columns L to S and find it in columns A to H, once found color the found cell in columns A to H green?

Best regards,
Trowa