Conditional Formatting on Color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to conditionally format a cell to a color only if a referenced
cell is already conditionally formatted to a color. Ex; format cell A2 to red
if cell A1 is conditionally formatted to yellow?
 
You can check for the same logic applied to the other conditionally formatted
cell. Using your example, if A1 is conditionally formatted to yellow when
the cell value is > 1, then, you can conditionally format A2 to red with the
formula "=A1>1"
 
I think that is in the right directions. Can I format the cell for multiple
conditions. Ex: Format A1 to yellow if B1 is >1, then format A2 to red if B2
is >1 and B1 >1?
 
Thank you for the help, I knew there was an easier way than trying to look at
the color properties of the cell.
 

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.

Ask a Question

Back
Top