cell formating

  • Thread starter Thread starter Pat DeStasio
  • Start date Start date
P

Pat DeStasio

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?
 
Yes you can. Obviously though, this will be based on the cell meeting
certain criteria. Why not use conditional formatting to do this?
 
Thanks Kassie, This will be my first attempt at conditional formatting. I'll
play around it some, thanks again
 
You must log in or register to reply here.

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

Similar Threads

Changing cell colors from a function command 3
What does the yellow triangle with an exclamation mark in Outlook mean? 1
Conditional formatting dates 3
Counting Cells by Format 2
How to Color a Cell Based on a Range of Cells with Colors 1
Using the Icon Set for Conditional Formatting 1
Cell Color Recognition and Summing of Data Within a Specified Colo 1
Excel Excel due and overdue date colours 2

Back
Top