Can you please help with code to change the row font color to Green if column says "NH", Black if "TRANS" and red if "TERM". The type ( NH,Trans and Term) will be in column E. The background will stay white. Note there are multiple spreasheets in the file this would only be on the a spreadsheet named tracking
Thank you
Last edited by ariel20029; 04-28-2012 at 11:44 AM.
See if this helps...
Highlight range
In conditional formatting
=$E1="NH"
Just add more conditions for your other criterias
http://www.contextures.com/xlcondformat02.html
Last edited by jeffreybrown; 04-28-2012 at 11:23 AM.
HTH
Regards, Jeff
so sorry ab out the tags. I was really looking for code to do the formatting. Each month the range can change and I do not want to have to keep changing the range in the conditional formatting.
How about
Please Login or Register to view this content.
Last edited by jeffreybrown; 04-28-2012 at 12:48 PM.
thank you!!
Your are very welcome and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks