Hello,
I´m using Excel and need to change the VALUE of a cell (need to appear "-") if the COLOR of another cell is PURPLE.
After digging around with conditional formatting, I'm looking the IF function but I can´t find wich property I could use to give me the color of a cell.
Any help is wellcome!
Thanks in advance!
PS: I´ll post back if I manage to work it out!...
PS2: There is a property called "Cell" wich has a "color" code but still isn't giving me what I need...
Related:
Change a cell content according with the color of another cell