Conditional Format for font color using font color

[Jim]

Is there a way for setting up a conditional format using another cell's font
color. I'm importing data into a spreadsheet that has font color formatting
and want to format other cells based on the font color.

 

[Pete_UK]

You can't do that with standard conditional formatting.

Pete

 

[Michael.Tarnowski]

You can't do that with standard conditional formatting.

Pete

Hi,
have a look at the advanced search "colour" on ozgrid.com (VBA area):

http://www.ozgrid.com/search/ozgrid...cof=FORID:11&ie=UTF-8&q=colour&sa=Search#1068

(be carefull with potential linebreaks in this URL)

Hope that helps.
Michael