View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Format cell based on cell color

How did your cells in Columns B through AO get to be "red filled"...
manually filled with the color or via Conditional Formatting? If Conditional
Formatting, what formula was used?

--
Rick (MVP - Excel)



"Jim" wrote in message
...
Is there a way to format the cell in column A "Red Fill" if there is any
cell
in that row in columns B through AO that have a Red filled cell?

If not, is there a way to color the cell in column A if the cell in column
B
is Red filled? If that's possible, I could set up a macro to repeat the
process for the other columns.

Thanks for your help
Jim