#1   Report Post  
Pat DeStasio
 
Posts: n/a
Default cell formating

Does anyone know if you can add a line or two to a macro to look through
several columns of data, find the cells that are formatted yellow and change
the yellow to red?


  #2   Report Post  
Kassie
 
Posts: n/a
Default

Yes you can. Obviously though, this will be based on the cell meeting
certain criteria. Why not use conditional formatting to do this?

"Pat DeStasio" wrote:

Does anyone know if you can add a line or two to a macro to look through
several columns of data, find the cells that are formatted yellow and change
the yellow to red?



  #3   Report Post  
Pat DeStasio
 
Posts: n/a
Default

Thanks Kassie, This will be my first attempt at conditional formatting. I'll
play around it some, thanks again

"Kassie" wrote in message
...
Yes you can. Obviously though, this will be based on the cell meeting
certain criteria. Why not use conditional formatting to do this?

"Pat DeStasio" wrote:

Does anyone know if you can add a line or two to a macro to look through
several columns of data, find the cells that are formatted yellow and

change
the yellow to red?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell formating Gerardo Excel Discussion (Misc queries) 1 March 10th 05 03:06 AM
conditional formating for a blank cell wsoung Excel Discussion (Misc queries) 5 March 9th 05 11:15 PM
Can a Formula in Cell X modify Cell Y? alMandragor Excel Discussion (Misc queries) 7 February 10th 05 10:51 PM
Formating cell to 1000 BMBCNJ Charts and Charting in Excel 3 December 15th 04 04:52 AM
color formating ontingenton upon another cell? jacob farino Excel Discussion (Misc queries) 1 December 2nd 04 06:05 AM


All times are GMT +1. The time now is 09:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"