View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Conditional format a cell based on color of another

You don't need the IF(...,1,0)
Your formula could be merely =A10
--
David Biddulph

"Daryl Fagala" wrote in message
...
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:

=IF(A10,1,0)

"Marlo" wrote:

Hi,
I would like to conditional format cell a2 to red only if a1 is red. Does
anyone knows how to do that?
Thanks