LinkBack URL
About LinkBacks
I have a spreadsheet and im hoping to add a macro or something so that if a column is the 'wrong' number, it will change the color of the entire row. i used an if statement to Say OK or NO, and i would like it to change colors if NO appears.
I have a spreadsheet and im hoping to add a macro or something so that if a column is the 'wrong' number, it will change the color of the entire row. i used an if statement to Say OK or NO, and i would like it to change colors if NO appears.
Have you tried conditional formatting?
JR
Versions
Mac OS X 'Leopard'
Mac MS Office Excel 2004
Windows XP
MS Excel 2002
MS Excel 2003
nope, have no idea what im doing.
open up the excel help file from the toolbar menu at the top (file, view etc) and put conditional formats in the search option then in the list it will present you look for Add, change or remove conditional formats and then look under the add drop down menu. It will explain how to apply conditional formatting better than i can.
Hope it helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks