Hello, i have been trying to record conditional formatting via macro however this does not seem to work at all. Huge dilemma! I was wondering if some one could provide a few simple sample conditional formatting macros which i could then edit/manipulate to create my conditional formatting.
Ive given a small list of the formats required.
1. if cells in range = blank fill with (colour index "x")
2. if cell below ="staff" fill with (colour indedex "x")
3. if cell 15 to the left isnumber fill with colour index x and make font colour index x.
4. if cell to the left = "staff id" apply border to the right hand side of this cell
5. if cell above ="staff" format cells to "#-#-#"
(# represeenting numbers)
Any help what so ever on any of these tasks will be greatly appreciated!
Many thanks Alan
Bookmarks