Sejwal_Manish
New Member
I am looking to highlight cells based on the linked formula or as the
cell changes the linked sheet.
For instance, in the attached excel sheet, up until 2020 - cell values
are hardcoded, while from 2021 to 2023- they are based on sheet 2
while from 2024 onwards cell values are based on sheet 3. Currently I
have highlighted them manually.
Likewise, for row#6- cell values are based on formulae within the sheet but not linked to other sheet in the file.
Is there a way to highlight them by conditional formatting using some formulae?
cell changes the linked sheet.
For instance, in the attached excel sheet, up until 2020 - cell values
are hardcoded, while from 2021 to 2023- they are based on sheet 2
while from 2024 onwards cell values are based on sheet 3. Currently I
have highlighted them manually.
Likewise, for row#6- cell values are based on formulae within the sheet but not linked to other sheet in the file.
Is there a way to highlight them by conditional formatting using some formulae?