Forum Discussion
Solved
Conditional Formatting based on comparing cell references
Hi All, I have a rate spread sheet (below) that has 7 columns: A B C D E F G 1 Cost Descr Cost Amount Rate Applied Rate Factor Current Rate (light green) Live Rate (lig...
OK, try this.
Hello, would you mind uploading your file so I can use it to add the things you need there and then I can upload the solution?
Best,
Best,
ricardojose here you go. Thanks
alex_n , here you go!
BestThe pseudo example would be as follows:
if (the content of D2 is "=E2", then format D2 cell fill to light green color)
D2: Rate Factor
E2: Current Rate (light green color column)
I tried to use Indirect() function with combination of Address() function but could not get it to the level it would work. I may be doing something wrong here.
