LinkBack URL
About LinkBacks
Conditional formating, 2010 is new, and have not worked too much with conditinal formating, please see attached for help with formating conditions.
Conditional formating, 2010 is new, and have not worked too much with conditinal formating, please see attached for help with formating conditions.
What conditional formatting do you want to apply and to which cells?
If posting code please use code tags, see here.
the notes for conditional formating are within the spreadsheet, i typed what is needed
Ah, missed that.
Still not clear which ranges to apply it do though.
the range for across is within the cells (A-AD) as far as how far to go down with the spreadsheet you can set a limit to cell 5000 or infinate (if thats possible)
Time to get your feet wet!
Here is a tutorial on Conditional Formatting for Excel 2007/2010
Here is a link to many video demo's at YouTube on the topic
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Try this.
Select Z2:Z5000, goto conditional formatting, select the Use formula... option, enter this formula,
=$J2<>"CS"
and format as required.
Select A2:AD5000, goto conditional formatting, select the Use formula... option, enter this formula,
=$P2="VOID
and format as required.
Select V2:V5000, goto conditional formatting, select Format Only cells... option and select No Blanks from the dropdown and format as required.
almost there i was able to take some info you gave and got to work as i needed, but still stuck on conditional format horzontal, see last two comments. Feel free to add to workbook and try out
Why didn't you use what I suggested for the 2nd format?
You need the 'Use formula...' option if you want to format cells other than the one you are checking.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks