You'll need to write a formula in a2 that points to a1 and returns a value
you can use for conditional formatting; e.g., if your conditional format for
a1 is set to make it red if its value is greater than 0, you could write the
following formula in a2 with the same conditional format:
then you can also change the format of the cell font color and use the
conditional formating when you want it to show up or not.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.