Hi, I need some help in what I am trying to do. I have two columns in my spread sheet and I want to compare individual cells and format it accordingly. For instance if cell B1 > C1, then fill the color of B1 to red and if B1 < C1 fill it with green. I want to do this for about 1500 entries. I have tried using conditional foramting, but I cant seem to work across all the 1500 entries. it just works for the first and compares all other entries to the first giving me incositent foramting. I would greatly appriciate any of your help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
If statements and formating 1
- Thread starter coughnut
- Start date
-
1
- #2
- Thread starter
- #3
MallardVHS
Technical User
mintjulep - count me impressed. OP never mentioned dolloar signs!
don
- Status
Similar threads
- Locked
- Question